Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
modify a form on the fly
I have a form with multiple texbox controls. I want the number of these
controls to change based on the number of worksheets in the workbook. What I have currently is a form with 36 textbox controls. If I only have 30 worksheets, then the last 6 are hidden. If, however, the user wants to add worksheets until there are greater than 36, then I have to manually edit the code and form so that there will be enough textboxes for the worksheets. So, is there a way to modify the form so that when a worksheet is added (or removed) a new textbox will be added (or removed) from the form? I should add there is small amount of code associated with each textbox_change event that would also need to be added or removed. .... The other option would be to redesign the form entirely, though I'm not quite sure how to make that happen. The workbook is a financial planner, with each sheet functioning as basically an account register. The form in question allows one to make a transfer of funds from one sheet (chosen by a combobox) to one or multiple other sheets (represented in the multiple textboxes). The essential function of the form is to allow multiple transactions at the press of one button, rather than making multiple individual transactions. Any ideas for either method? Thanks drhalter using XL 2003 SP3 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Modify Automatic Form | Excel Discussion (Misc queries) | |||
User Form to Modify Row | Excel Programming | |||
Replace/modify standard data form? | Excel Discussion (Misc queries) | |||
Using a form to modify a list | Excel Programming | |||
Can I create a FORM (that I can modify etc) from an existing spreadsheet? | Excel Programming |