Change Tab Order of UserForm TextBoxes Conditionally
 

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

Change Tab Order of UserForm TextBoxes Conditionally
 

Textbox3.TabStop = bln1

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


--
Regards,
Tim Zych
http://www.higherdata.com
Workbook Compare - Excel data comparison utility

"Minitman" wrote in message
...
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