+ Reply to Thread
Results 1 to 1 of 1

VBA Data Entry Form

  1. #1
    Registered User
    Join Date
    08-06-2013
    Location
    Thetford, England
    MS-Off Ver
    Excel 2013 / 365
    Posts
    8

    VBA Data Entry Form

    Hello All

    I am currently working on an enquiry register that has many columns/rows, but I would like to create a data entry form to input data in a range of columns/rows (names, contact details etc): D24:Q5023. The column titles are in row 23, ie. D23:Q23 & all the rows are already numbered in column C, ie. C24:C5023. Is it possible to create a data entry form using VBA, that automatically generates when a user selects any of the cells within the specified range, with the column titles as the fields. I would also like to be able to search for data within the form, if possible including the No. (column C) within the search. If this is possible, I would then like to hide some of the columns within that range, but still be able to input the data to be held within those columns on the data entry form. Please note that I already have VBA on the worksheet allowing check boxes, hiding autofilter arrows, & a date stamp. Please see this below:

    Please Login or Register  to view this content.
    Any suggestions would be greatly appreciated.

    Many Thanks in advance

    Moderator Note:

    Pls use code tags around your code next time as per forum rules.
    Last edited by Harls; 10-10-2013 at 11:18 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 09-24-2013, 11:01 AM
  2. Data entry form
    By jcaynes in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-05-2013, 08:34 PM
  3. Replies: 2
    Last Post: 06-07-2013, 09:08 AM
  4. Data Entry Form Help
    By Patchworks in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-14-2009, 08:52 PM
  5. Data Entry Form (similar to default Excel Data>Form)
    By tonydm in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-11-2005, 02:59 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1