Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Name of Current TextBox on Userform
I have a user form that has a number of text boxes named "T1", "T2", "T3",
etc. I am writing a procedure in which I would like to access the text box name (since there are different items to put into the text box depending on the identity of the text box). Specifically, I would like to create a variable by a command such as tmp_box="T"&str(box_nbr) When I then try to use this variable in something like frm_name.tmp_box.value It doesn't use the "T1", "T2", etc. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Name of Current TextBox on Userform
Try it this way...
Me.Controls(tmp_box).Text Rick "dunnerca" wrote in message ... I have a user form that has a number of text boxes named "T1", "T2", "T3", etc. I am writing a procedure in which I would like to access the text box name (since there are different items to put into the text box depending on the identity of the text box). Specifically, I would like to create a variable by a command such as tmp_box="T"&str(box_nbr) When I then try to use this variable in something like frm_name.tmp_box.value It doesn't use the "T1", "T2", etc. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Name of Current TextBox on Userform
Great, Rick. Many thanks .... again.
"Rick Rothstein (MVP - VB)" wrote: Try it this way... Me.Controls(tmp_box).Text Rick "dunnerca" wrote in message ... I have a user form that has a number of text boxes named "T1", "T2", "T3", etc. I am writing a procedure in which I would like to access the text box name (since there are different items to put into the text box depending on the identity of the text box). Specifically, I would like to create a variable by a command such as tmp_box="T"&str(box_nbr) When I then try to use this variable in something like frm_name.tmp_box.value It doesn't use the "T1", "T2", etc. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to force selection of all current text in textbox control onentry? | Excel Programming | |||
Userform Textbox | Excel Programming | |||
Userform textbox help | Excel Programming | |||
textbox setfocus and select current contents | Excel Programming | |||
UserForm TextBox to ActiveSheet TextBox over 256 characters | Excel Programming |