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

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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

Thanks Tim,

That works very well.

Thanks

-Minitman




On Tue, 23 Jun 2009 17:39:19 -0700, "Tim Zych" <tzych@nospam at
earthlink dot net> wrote:

>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" <(E-Mail Removed)> wrote in message
>news:(E-Mail Removed)...
>> 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
>