tab textbox by a macro

A

Alberto Ast

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?
 
O

OssieMac

Hi alberto,

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

Me.TextBox2.SetFocus
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top