View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
OssieMac OssieMac is offline
external usenet poster
 
Posts: 2,510
Default tab textbox by a macro

Hi alberto,

At the end of the code run by CommandButton1 insert the following.

Me.TextBox2.SetFocus

--
Regards,

OssieMac


"Alberto Ast" wrote:

I have some textbox in a user form...
I start on textbox1 and then once it is filled in a click commandbuttom1..
This click will populate some data then I then would like the cursor to move
to textbox2...

How do I do it with a macro and not expecting user to hit tab or enter?