View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Halim Halim is offline
external usenet poster
 
Posts: 182
Default send focus to a textbox

Hi,
You can use this :

Private sub UserForm_Activate()\
Textbox1.setfocus
End Sub
--

Regards,

Halim


"TimT" wrote:

Hello all,
When my file opens I want it set the focus on a textbox that holds a user
agreement in it with scrollbars.
I want it to set the focus on the text box so that it starts at the
beginning of the verbiage that's written in it.
Any help?