Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 81
Default 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?


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7,247
Default Tab indexing

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 94
Default Tab indexing

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7,247
Default Tab indexing

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 81
Default Tab indexing

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Indexing TWP Excel Discussion (Misc queries) 5 April 22nd 09 11:10 PM
Indexing Anto111 Excel Discussion (Misc queries) 1 July 26th 08 08:01 PM
Indexing M&M[_2_] Excel Discussion (Misc queries) 1 July 13th 07 07:10 PM
Indexing of Name Charlie Excel Worksheet Functions 1 April 5th 06 01:33 PM
Indexing a row ecohen1 Excel Worksheet Functions 6 July 20th 05 06:11 PM


All times are GMT +1. The time now is 03:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"