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:
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.
Bookmarks