Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
switching between 2 arrays in one form
Hi
I wonder if someone can discuss the following problem and to come up with a possible solution. I have a form with the need for 2 small arrays one relating to height one relating to drop The arrays allow the user to put in sizes of different measurements and are used to keep a running total. There is a 2 option buttons called width and drop and by toggling this i would like to dynamically swap betweent the arrays without losing the data. I understand when i change the swap ... that i need to repopulate the form with the correct array data. The caculation to the arrays are identical.. and i have something called testarray which is currently my coded version to test the data going in, but i do not know if i can create a varaiable from the options button which will basically swap test_array for width_array or drop_array as variable names.. i presume the only other way is to create a function which pushes the selected name to the routine which manipulates and stores the array ... Any ideas ? Thanks in advance Devo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Switching between Workbooks | Excel Discussion (Misc queries) | |||
switching x axis | Charts and Charting in Excel | |||
Switching Text | Excel Discussion (Misc queries) | |||
switching the worksheet? | Excel Discussion (Misc queries) | |||
declaring Arrays to use in a Form with few modules | Excel Programming |