ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   switching between 2 arrays in one form (https://www.excelbanter.com/excel-programming/366730-switching-between-2-arrays-one-form.html)

devo

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




All times are GMT +1. The time now is 03:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com