Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
"lcaretto" wrote in message
Peter -- thanks for the reply. First of all this won't work Dim textBoxArray(1 To numberOfInputs) As TextBox Either use ReDim or hardcode numberOfInputs In my code I used the statement "const numberOfInputs = 3" to set the array dimension as (1 to numberOfInputs). This works fine and allows me to use the const value (as numberOfInputs) in other parts of the code. Ah, that makes more sense. Regards, Peter T |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Link Text Boxes on Form? | Excel Discussion (Misc queries) | |||
User Form Text Boxes - Copy format of text boxes | Excel Discussion (Misc queries) | |||
Setting Property Values of Text Boxes within Forms | Excel Programming | |||
Form Text Boxes moving | Excel Worksheet Functions | |||
Re-setting the serial number of text boxes | Excel Programming |