Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How stop Excel file UK date order changing to US order in m.merge | Excel Discussion (Misc queries) | |||
Display Pivot table summary in order of increasing time frame | Excel Discussion (Misc queries) | |||
frame | Excel Discussion (Misc queries) | |||
How to attach legend frame to chart frame? | Charts and Charting in Excel | |||
tab order in frame control | Excel Programming |