Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Help,
How can I assign a value to a textbox on a userform without looping through all the textboxes. Is it possible to assign the name of the textbox to a string and use that string to immediately assign a value to the textbox with that name? Example: dim sMo as string dim sCapExp as string dim sTxb as string sMo="Jun" sCapExp="Cap" sTxb="txb" & sMO & sCapExp Is there something like the Sheets object where you can place the name in parenthesis, i.e. sheets("Summary"). can you do, Textbox(sTxb).Value = "it works"? Please let me know, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Concatinate name and date | Excel Discussion (Misc queries) | |||
Concatinate Formatting | Excel Discussion (Misc queries) | |||
concatinate data | Excel Worksheet Functions | |||
concatinate and vlookup | Excel Programming | |||
Concatinate a filename | Excel Discussion (Misc queries) |