How do I turn an Object name into an Array.
Example I ahave 10 checkboxes and I´d like to turn them into a array to use in a loop.
Note I am using Visaul Basic for EXCEL MACROS and simply copying the name or putting the name in the name type column can´t be done. How do I do this for Excel Macros???
say: (chkBox(#) being the name of the checkboxs)
Dim i as Integer
For i= 1 to 10
chkBox(i)= i
Next i
Example I ahave 10 checkboxes and I´d like to turn them into a array to use in a loop.
Note I am using Visaul Basic for EXCEL MACROS and simply copying the name or putting the name in the name type column can´t be done. How do I do this for Excel Macros???
say: (chkBox(#) being the name of the checkboxs)
Dim i as Integer
For i= 1 to 10
chkBox(i)= i
Next i
