Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello! I have a user form in which I read values from text boxes and check
boxes. I then want to store these values in arrays. My code is now written so that I give values to the arrays directly. However it would be better to loop this process, a task that I seem to fail since I do not know how to handle the reference to the text boxes and check boxes. My code: checkBoxArray(0) = CheckBox1.Value checkBoxArray(1) = CheckBox2.Value checkBoxArray(2) = CheckBox3.Value checkBoxArray(3) = CheckBox4.Value I can replace the number refering to the place in the array with a variable but is it possible to handle the check boxes in the same manner i.e. refer to the by the usage of a variable? If so is there any function that counts the number of check boxes in a user form? I am greatful for any assistance that you can give me. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Tab Naming | Excel Worksheet Functions | |||
Tab Naming | Excel Discussion (Misc queries) | |||
Tab naming | Excel Discussion (Misc queries) | |||
VBA - Looping thro same naming files in 2 directories........PLEASE HELP | Excel Programming | |||
Naming | Excel Programming |