I creating a giant form by inserting ActiveX controls into multiple worksheets. It is linked to an Access database using Excel's Template Wizard. I use text boxes instead of having the user type directly into a cell and I want the user to be able to tab throught all the text boxes. When you create a UserForm in the VB editor you can set the tab order, but here I cannot tab through at all.
Also, because the form covers several worksheets, I would like for the Access database that the Template Wizard creates to put the info into several tables, but I don't see a way to do this.
If anyone is familiar with the Template Wizard and inserting ActiveX controls into worksheets, I would really appreciate the help!
Also, because the form covers several worksheets, I would like for the Access database that the Template Wizard creates to put the info into several tables, but I don't see a way to do this.
If anyone is familiar with the Template Wizard and inserting ActiveX controls into worksheets, I would really appreciate the help!