Textbox focus

peter.thompson

New Member
Joined
Dec 27, 2005
Messages
3
How do I get the cursor to to go to a specific text box each time a user opens the form

Cheers and thanks

Peter (new to VBA)
 

Some videos you may like

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

jindon

MrExcel MVP
Joined
Aug 21, 2004
Messages
16,995
Hi

in the Form Initialize event

textbox.setfocus method will do the job.

refer vb help for setfocus

do you play golf byt the way?
 

Watch MrExcel Video

Forum statistics

Threads
1,118,530
Messages
5,572,680
Members
412,481
Latest member
nhantam
Top