Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SpinButton control and focus | Excel Programming | |||
Show userform without it taking focus? | Excel Programming | |||
Set Focus Problem for textbox control on multipage control | Excel Programming | |||
Focus on Control before UserForm(s) pop up | Excel Programming | |||
UserForm Loss Focus | Excel Programming |