Tab indexing

I have set my tab indexes in a userform. when I try to set them for check
boxes and option buttons, they automatically convert to 0 for the index tab.
How can I get the tab to stop on a check box or option button?

Are your check boxes and option buttons within a Frame control?
If so, set the TabIndex of the Frame to the appropriate value,
and then order the controls within the form starting over at 0.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"juliejg1" <[email protected]> wrote in message
news:[email protected]...
>I have set my tab indexes in a userform. when I try to set them
>for check
> boxes and option buttons, they automatically convert to 0 for
> the index tab.
> How can I get the tab to stop on a check box or option button?
>
>

> and then order the controls within the form starting over at 0.
should be
and then order the controls within the Frame starting over at 0.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Chip Pearson" <[email protected]> wrote in message
news:uFBI%[email protected]...
> Are your check boxes and option buttons within a Frame control?
> If so, set the TabIndex of the Frame to the appropriate value,
> and then order the controls within the form starting over at 0.
>
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com
>
>
> "juliejg1" <[email protected]> wrote in
> message
> news:[email protected]...
>>I have set my tab indexes in a userform. when I try to set them
>>for check
>> boxes and option buttons, they automatically convert to 0 for
>> the index tab.
>> How can I get the tab to stop on a check box or option button?
>>
>>
>
>

Set the Value property of the option button or checkbox to TRUE. This will
"turn on" the option button/checkbox.

Regards,
Edwin Tam
[email protected]
http://www.vonixx.com


"juliejg1" wrote:

> I have set my tab indexes in a userform. when I try to set them for check
> boxes and option buttons, they automatically convert to 0 for the index tab.
> How can I get the tab to stop on a check box or option button?
>
>

Thats what it was...thnx!

"Chip Pearson" wrote:

> > and then order the controls within the form starting over at 0.
> should be
> and then order the controls within the Frame starting over at 0.
>
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com
>
>
> "Chip Pearson" <[email protected]> wrote in message
> news:uFBI%[email protected]...
> > Are your check boxes and option buttons within a Frame control?
> > If so, set the TabIndex of the Frame to the appropriate value,
> > and then order the controls within the form starting over at 0.
> >
> >
> > --
> > Cordially,
> > Chip Pearson
> > Microsoft MVP - Excel
> > Pearson Software Consulting, LLC
> > www.cpearson.com
> >
> >
> > "juliejg1" <[email protected]> wrote in
> > message
> > news:[email protected]...
> >>I have set my tab indexes in a userform. when I try to set them
> >>for check
> >> boxes and option buttons, they automatically convert to 0 for
> >> the index tab.
> >> How can I get the tab to stop on a check box or option button?
> >>
> >>
> >
> >
>
>
>