Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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" wrote in message ... 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? |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Set the Value property of the option button or checkbox to TRUE. This will
"turn on" the option button/checkbox. Regards, Edwin Tam 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? |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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" wrote in message ... 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" wrote in message ... 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? |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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" wrote in message ... 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" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Indexing | Excel Discussion (Misc queries) | |||
Indexing | Excel Discussion (Misc queries) | |||
Indexing | Excel Discussion (Misc queries) | |||
Indexing of Name | Excel Worksheet Functions | |||
Indexing a row | Excel Worksheet Functions |