Looping Through a Task

[MGumbrell]

On UserForm1

I have 15 TextBox's (TextBox1 to TextBox15)

I have an OptionButton1

What I would like to happen
When OtionButton1 is checked, then TextBox's 1 to 15.Enabled = False

I just can't work out how to loop through this event. I suppose what I am really after is learning the process for looping through an event such as this.

Thanks, Matt

 

[allan57]

dim bytTextBoxCounter as byte

for bytTextBoxCounter=1 to 15
me("TextBox" & bytTextBoxCounter).enabled = false
next bytTextBoxCounter

 

[MGumbrell]

Thanks for that.

Can you tell me what the "me" syntax means and how it is used.

Regards, Matt

 

[shades]

"Me" is shorthand used to refer to the current/active UserForm.
________
Vaporizer Store

 

[HaHoBe]

Hi, Matt,

otherwise use

Controls("TextBox" & bytTextBoxCounter).Enabled = False

Ciao,
Holger

 

[MGumbrell]

Thanks Guys

Regards, Matt