View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] marston.gould@alaskaair.com is offline
external usenet poster
 
Posts: 102
Default 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?