concatinate a textbox name
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,
|