Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Custom Menu
I have this code on a custom menu option:
With CustomMenu.Controls.Add(Type:=msoControlButton) .Caption = "Process This Labor Summary" .OnAction = UserForm2.Show End With And this code on activation: Private Sub UserForm_activate() Call PRProc End Sub But this does not work. How do I have a menu option load a form which then calls a process? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Custom Menu
First try:
Private Sub UserForm_activate() MsgBox ("Hi Mike") End Sub just to make sure the button is connected to the handling sub. Then, with your original code, make su PRProc has been declared in a nice Public fashion. -- Gary''s Student - gsnu200748 "Mike H." wrote: I have this code on a custom menu option: With CustomMenu.Controls.Add(Type:=msoControlButton) .Caption = "Process This Labor Summary" .OnAction = UserForm2.Show End With And this code on activation: Private Sub UserForm_activate() Call PRProc End Sub But this does not work. How do I have a menu option load a form which then calls a process? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Displaying A custom menu as a popup menu | Excel Programming | |||
Custom Menu and Menu Items | Excel Programming | |||
Adding Sub Menu Item to Current Custom Menu | Excel Programming | |||
VBA - Disappearing custom menu and custom toolbar | Excel Programming | |||
Custom Menu return to Excel Menu upon Closing | Excel Programming |