Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
JT JT is offline
external usenet poster
 
Posts: 234
Default Tab Order within a frame

I have a form that I'm trying to set the tab order. There are 6 items within
a frame, 5 text boxes, and 2 buttons. I've coded the tab order so it should
tab
through the (1) 2 text boxes, (2) 2 buttons, (3) 3 text boxes, and then (4)
the 6 items in the frame. The frame has 5 radio buttons and 3 more text
boxes.

However, when I try to tab throught the items it works like I expect for the
items outside of the frame and most if the items within the frame. I can tab
through the 5 radio buttons and then I expect it to tab through the 3 text
boxes (within the frame). But that does not happen. It tabs through the 5
radio buttons in the frame and then jumps back to the first text box (outside
of the frame).

I'm trying to get it to tab through the 3 text boxes (within the frame)
after the 5 radio buttons. I've checked the properties and I think I have
them all set correctly. Is there a way around this or do I have to add
another frame for the last 3
text boxes within my original frame?

Thanks for the help...............

--
JT
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Tab Order within a frame

I set up a userform as you describe and it worked fine for me.

then (4)
the 6 items in the frame. The frame has 5 radio buttons and 3 more text
boxes.


although you said 6 items, I added 8 items - 5 radio buttons and 3
textboxes.
--
Regards,
Tom Ogilvy


"JT" wrote in message
...
I have a form that I'm trying to set the tab order. There are 6 items

within
a frame, 5 text boxes, and 2 buttons. I've coded the tab order so it

should
tab
through the (1) 2 text boxes, (2) 2 buttons, (3) 3 text boxes, and then

(4)
the 6 items in the frame. The frame has 5 radio buttons and 3 more text
boxes.

However, when I try to tab throught the items it works like I expect for

the
items outside of the frame and most if the items within the frame. I can

tab
through the 5 radio buttons and then I expect it to tab through the 3 text
boxes (within the frame). But that does not happen. It tabs through the

5
radio buttons in the frame and then jumps back to the first text box

(outside
of the frame).

I'm trying to get it to tab through the 3 text boxes (within the frame)
after the 5 radio buttons. I've checked the properties and I think I have
them all set correctly. Is there a way around this or do I have to add
another frame for the last 3
text boxes within my original frame?

Thanks for the help...............

--
JT



  #3   Report Post  
Posted to microsoft.public.excel.programming
JNW JNW is offline
external usenet poster
 
Posts: 480
Default Tab Order within a frame

Try right clicking on the userform (not the frame) and selecting tab order.
Then set that order placing the frame where you would like to have it. After
that, right click inside the frame and do the same for the items inside the
frame. If that doesn't work, make sure that all items you want to have a tab
stop at have the TabStop property marked as true.



"JT" wrote:

I have a form that I'm trying to set the tab order. There are 6 items within
a frame, 5 text boxes, and 2 buttons. I've coded the tab order so it should
tab
through the (1) 2 text boxes, (2) 2 buttons, (3) 3 text boxes, and then (4)
the 6 items in the frame. The frame has 5 radio buttons and 3 more text
boxes.

However, when I try to tab throught the items it works like I expect for the
items outside of the frame and most if the items within the frame. I can tab
through the 5 radio buttons and then I expect it to tab through the 3 text
boxes (within the frame). But that does not happen. It tabs through the 5
radio buttons in the frame and then jumps back to the first text box (outside
of the frame).

I'm trying to get it to tab through the 3 text boxes (within the frame)
after the 5 radio buttons. I've checked the properties and I think I have
them all set correctly. Is there a way around this or do I have to add
another frame for the last 3
text boxes within my original frame?

Thanks for the help...............

--
JT

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
How stop Excel file UK date order changing to US order in m.merge Roger Aldridge Excel Discussion (Misc queries) 1 October 9th 07 11:52 PM
Display Pivot table summary in order of increasing time frame Hari Excel Discussion (Misc queries) 4 January 3rd 07 01:16 PM
frame Nick London Excel Discussion (Misc queries) 0 July 4th 06 01:17 PM
How to attach legend frame to chart frame? holg3r Charts and Charting in Excel 2 July 7th 05 11:41 PM
tab order in frame control mike Excel Programming 2 February 19th 04 03:42 PM


All times are GMT +1. The time now is 10:59 PM.

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

About Us

"It's about Microsoft Excel"