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