| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Take Focus Off of CommandButton When Exiting UserForm
Greetings,
I have a Toolbar CommandButton on my worksheet that is used to call up a UserForm. When I exit the UserForm, the CommandButton still has the focus. Is there anyway to restore the focus to the worksheet as I exit the UserForm? Your help is greatly appreciated. TIA -Minitman |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Take Focus Off of CommandButton When Exiting UserForm
CommandBars.ReleaseFocus
"Minitman" wrote: Greetings, I have a Toolbar CommandButton on my worksheet that is used to call up a UserForm. When I exit the UserForm, the CommandButton still has the focus. Is there anyway to restore the focus to the worksheet as I exit the UserForm? Your help is greatly appreciated. TIA -Minitman |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Take Focus Off of CommandButton When Exiting UserForm
Thanks
-Minitman On Fri, 17 Nov 2006 11:45:02 -0800, JLGWhiz wrote: CommandBars.ReleaseFocus |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Run a procedure when exiting a a textbox within a userform | Excel Programming | |||
| Exiting a procedure with a userform | Excel Programming | |||
| CommandButton - Userform | Excel Discussion (Misc queries) | |||
| Userform maintaining items in list box after exiting Excel | Excel Programming | |||
| Commandbutton in UserForm to run Macro | Excel Programming | |||
![Minitman[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
