set focus

M

MP

Hi there, I’m new to VB and having some difficulty with a text box.
I’m using textbox19 to enter values in a excel range of cells and want the
textbox to be clear and keep de focus set on the same text box, after I hit
the enter key, so I can enter the next value until I finish and then click
on another textbox.
Can anybody help?
I would appreciate.
 
P

Paul Herber

Hi there, I’m new to VB and having some difficulty with a text box.
I’m using textbox19 to enter values in a excel range of cells and want the
textbox to be clear and keep de focus set on the same text box, after I hit
the enter key, so I can enter the next value until I finish and then click
on another textbox.

Try in an Excel group, this one is for Visio.
 
Top