The intention of this workbook is to include a table, which lists straight data. This table will be used to extract reports from at a later date, which should hopefully be the easy step!
The catch is that I would like to have a second worksheet, which has the layout of a form. Once complete, I would like for users to be able to enter information on this form, which would then enter information into the table, on a separate worksheet. Then, once a full form has been entered into the 'table' worksheet, the plan is to have a button control which would run a macro, which would do the following:
- clear the form fields
- have the ediable fields on the form 'link' themselves to the next field on the table worksheet
At this stage, I have used ActiveX textbox controls on the form worksheet, and then used their Properties to link each control to the relevant table worksheet. This has worked wonderfully as far as inputting data across a single row, however I'm a bit stumped when it comes to creating a macro which may be able to alter the ActiveX properties (appears this may be impossible...!)
Any feedback is welcome. I'm a bit of an Excel newbie, and understand if going down the ActiveX line has been a waste of time. If this can be done without these controls, that would be great too.
Thanks.
Bookmarks