The Excel Form feature was not flexible enough for our purposes in building a database and so I created a custom data entry form using ActiveX controls and Excel's VBA. The data entry form has a Save function which saves the information entered into the ActiveX text boxes and combo boxes on the data entry form into a separate sheet (i.e. the "Database").
I would like to add a "scroll" feature that loads information from the database back into the relevant ActiveX fields on the data entry form so that certain entries can be modified and the data can be easily scrolled through. The standard Form feature in Excel has the scrollbar feature I am describing - is it possible to replicate this manually using Excel VBA?
Any tips or tutorial links would be very much appreciated!!
Bookmarks