View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
John Tjia John Tjia is offline
external usenet poster
 
Posts: 32
Default Text box on userform

Did you put this in the Userform_Initialize? Try changing the name of
the subroutine to Userform_Activate.

"pcrobinson" wrote in message ...
Hi
having loaded a userform I want to enter data in the first text box
without having to click in it with the mouse first. The tab order is correct
and I have tried the command "textbox1.setfocus"
in the userform initialization code but this does not work and I still have
to click the mouse in the text box before entering.
Thanks for any help
Peter