Name of Current TextBox on Userform

D

dunnerca

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top