Dear All,
I have little to no experience using excel.
I have a spreadsheet which has been made to look like a form with around 16 columns which act as headers/fields, the rows beneath will be data entries to be filled in by users. There will be multiple entries, hence multiple rows of data.
Selecting my column headers and clicking the FORM command excel brings up a window where I can add a value to the selected field, like a form!
How can I, by using a command button, simply click this button and begin filling out my form?? I want the user to click a single button and the window apper just as if hed selected the table headers and used the FORM command.
I have tried doing a bit of reading and experimenting and I found myself trapped in VBA with allsort of errors and other messages popping up. thought Id ask for some advise as most post i can find differ slightly from my issue.
Any help would be much appreciated as this piece of work is kind of urgent. Thanks in advance.
Bookmarks