Thanks very much Bob. Your first paragraph was the clue to my problem. I changed from Hide to Unload Me, and now it works perfectly. Thanks again, Bob - I appreciate it

Pau

----- Bob Phillips wrote: ----

Paul

It might be because the userform is being hidden, and so when it is nex
shown, the Initialize event is to used, that is for when it is loaded int
memory

Throw your code into the Userform_Activate() event code, and see if tha
fixes it

--

HT

Bob Phillip
... looking out across Poole Harbour to the Purbeck
(remove nothere from the email address if mailing direct

"Paul Simon" wrote in messag
..
I have Userform1 containing several textboxes. When I first open th
Excel file and open the Userform for the first time, the cursor correctl
appears in the first textbox (Textbox1). However, if I exit the Userfor
and then go back in, the cursor appears in another Textbox instead o
Textbox1. In fact, each time I exit the Userform and go back in, the curso
is in a different Textbox. (The TabIndex of Textbox1 is set to 0.
I've seen answers to several posts here giving a solution o
Userform1.Textbox1.SetFocus. I've put that line in the Private Su
UserForm_Initialize() code, but it has not affect
What code can I use so that whenever I open (show) Userform1, the curso
is always in Textbox1, and where do I place such code
Many thanks
Pau