ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Tab Stops (https://www.excelbanter.com/excel-programming/424451-tab-stops.html)

JT

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

Nigel[_2_]

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




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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com