View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
gtslabs gtslabs is offline
external usenet poster
 
Posts: 54
Default mouse pointer to be focused on userform command button upon opening

I am opening up a userform and I want the mouse pointer to be focused
on the command button I have so the user can quickly click it instead
of having to move the mouse and find the command button on the form.

Private Sub UserForm_activate()
TextBox1.Value = ActiveCell.Value
CommandButton1.SetFocus
commandbutton1.(make mouse pointer goto this command button)
End Sub