Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
UserForm_Activate not found
I have a routine in my one Userform....
Private Sub UserForm_Activate() Call Macro 1 End Sub I also have the following in my module code Set MenuItem = .... With MenuItem ..Caption = "Validate" ..OnAction = "UserForm_Activate" End With When I try to run the menuitem, I get The macro 'filename.xls!Userform_Activate' cannot be found. Any thoughts? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
UserForm_Activate not found
Private
So it can't be seen. However, you shouldn't call an event. Write a macro that does what you want and call that. If you want to show the userform Sub Macro23() Userform1.show End Sub -- Regards, Tom Ogilvy " wrote in message oups.com... I have a routine in my one Userform.... Private Sub UserForm_Activate() Call Macro 1 End Sub I also have the following in my module code Set MenuItem = .... With MenuItem .Caption = "Validate" .OnAction = "UserForm_Activate" End With When I try to run the menuitem, I get The macro 'filename.xls!Userform_Activate' cannot be found. Any thoughts? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Found this on one of my worksheets ???? | Excel Discussion (Misc queries) | |||
IF NOT FOUND | Excel Worksheet Functions | |||
not found | Excel Programming | |||
macro not found | Excel Programming | |||
File Not found | Excel Programming |