Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tab Stops
On a form I have 2 textboxes within a frame. I also have 5 buttons for the
user. I have the tabstops setup so that it flows from the textboxes through the 5 buttons. When you tab off of the last button, I want it to go to the first textbox. However, the user has to tab an extra time to get to the first textbox. I think it is going to the frame that contains the 2 textboxes. Is there anyway to make the tab skip the frame and go to the first textbox from the last button? Thanks for the help.... -- JT |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tab Stops
Try using the control exit event to drive focus back to the required
control...... Private Sub TextBox2_Exit(ByVal Cancel As MSForms.ReturnBoolean) TextBox1.SetFocus End Sub -- Regards, Nigel "JT" wrote in message ... On a form I have 2 textboxes within a frame. I also have 5 buttons for the user. I have the tabstops setup so that it flows from the textboxes through the 5 buttons. When you tab off of the last button, I want it to go to the first textbox. However, the user has to tab an extra time to get to the first textbox. I think it is going to the frame that contains the 2 textboxes. Is there anyway to make the tab skip the frame and go to the first textbox from the last button? Thanks for the help.... -- JT |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF just STOPS WORKING | Excel Worksheet Functions | |||
Stops at certain row with Error 91 | Excel Programming | |||
Tab Stops | Excel Programming | |||
Tab stops | Excel Programming | |||
Tab Stops | Excel Programming |