ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Form - Text Box Focus (https://www.excelbanter.com/excel-programming/338747-form-text-box-focus.html)

ceemo[_27_]

Form - Text Box Focus
 

I want to know how to set the focus from my text box to another when
tabbing

ive tried AfterUpdate() but that didnt seem to work and the user may
not always update just tab through

please help


--
ceemo
------------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=400523


Tom Ogilvy

Form - Text Box Focus
 
since afterupdate is only found in a userform, assume a userform:

Set the tabindex property of each textbox in the order you want.

--
Regards,
Tom Ogilvy


"ceemo" wrote in
message ...

I want to know how to set the focus from my text box to another when
tabbing

ive tried AfterUpdate() but that didnt seem to work and the user may
not always update just tab through

please help


--
ceemo
------------------------------------------------------------------------
ceemo's Profile:

http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=400523





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

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