Change Tab Order of UserForm TextBoxes Conditionally

[Minitman]

Greetings,

I have a 4 TextBoxes on a UserForm. I have them set-up to tab from
TextBox1 to TextBox2 skip TextBox3 going straight to TextBox4. I have
a Boolean variable called bln1. If true, I need for the tab order to
not skip TextBox3, but if bln1 is false then to leave the tab order as
default (1,2 & 4). The tab order is set with TabStop = True in the
properties window for TextBoxes 1,2 & 4 and set to false for TextBox 3

Any ideas as to how to perform this with vba?

Any help is appreciated.

Thanks for looking.

-Minitman

 

[Tim Zych]

Textbox3.TabStop = bln1

and the tab order should be fixed at Textbox1 = 1, Textbox2 = 2, Textbox3 =
3, Textbox4 = 4 in the properties dialog.

 

[Minitman]

Thanks Tim,

That works very well.

Thanks

-Minitman