View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Fred Holmes Fred Holmes is offline
external usenet poster
 
Posts: 112
Default Statement to give focus to a specific control on a UserForm?

I would like to put a statement in the intialization code (Private Sub
UserForm_Initialize()) of a UserForm to bring a certain textbox (or
any control) into focus. Something like

TextBox1.hasfocus = True

Is there a way to do this?

When I start to write such a statement in the VBA editor, I dont' find
anything dealing with focus in the list of properties and methods that
appears as context-sensitive help (sort of like a tool-tip)

When the Userform is "showning," the main menu of the Excel workbook
is grayed out, so I don't seem to be able to start the process of
recording a macro to see what the above code might be. Is there any
way to start a macro recording while the UserForm is "showing"? There
is no keyboard shortcut for starting "Record New Macro" on the main
Excel Menus, although I could go into keyboard customization and
assign one.

Thanks for any help.

Fred Holmes