View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default UserForm OnAction

..OnAction = "MyCode"


Sub Mycode()
frmMyUserForm.Show
End sub

--
Regards,
Tom Ogilvy


"Maria" wrote in message
...
Hi,

I have created a userdefined CommandBar with a button.
From this button I would like to start a UserForm.

Usually I use something like the following Codeline to
call a Prozedu
.OnAction = MyCode

I wanted to do the same with the UserForm:
.OnAction = frmMyUserForm

Unfortunately it doesn't work.
Is it possible to allocate a UserForm?

Thank you,
Maria