Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Have constructed a UserForm - frmDetail - with command buttons relevant to
worksheet Detail. It activates at the worksheet level for the Detail sheet [ie frmDetail.show]. 1. I only want it visible on the Detail sheet. Have tried Unload Me in that sheet's DeActivate procedure, but it doesn't work. 2. When the form is activated, it's focus is on the form itself, so worksheet ops are stalled unless I click somewhere in the worksheet. Prefer the focus to remain on the worksheet until a command button on the form is clicked, then revert the focus immediately back to the worksheet automaticall on that button being clicked. Note - there are no OK buttons, just command buttons that run procedures [ie Application.Run ...]. Thanx in advance for your assistance. Regards, - Mike |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Template for mechanics workorder (parts and labour) | Excel Discussion (Misc queries) | |||
fill userform textbox from userform listbox clik event | Excel Programming | |||
Is there an easy Copy/Paste of a Userform ? (Entire Userform Including tx & cbx's) | Excel Programming | |||
Looping procedure calls userform; how to exit loop (via userform button)? | Excel Programming | |||
Activating userform and filling it with data form row where userform is activate | Excel Programming |