I have a file attached with headers starting in A1-GC1. I would like to have a user form to add the information on to the sheet. Is there an easy way to do this?
Thanks
I have a file attached with headers starting in A1-GC1. I would like to have a user form to add the information on to the sheet. Is there an easy way to do this?
Thanks
Hello Wskip49,
If you mean easy as in "is there something already made for this" then the answer is no. What you are asking for is a custom database user interface. To easiest way to arrange setting up the UserForm would be to use a MutliTab control. First you would need to breakdown your data in functional groups, like address data. These group names would be placed on the tabs of the MultiTab control. When a tab is clicked, a new page of information is displayed for the user to fill in. Each page would hold the controls necessary to gather the user's data. Code would then need to be added to transfer and format the data back to the worksheet. It is not a small and quick job.
Sincerely,
Leith Ross
Thanks Leith I'll try that.
Skip
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks