View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default How to call an event procedure

Hi Ben,

If the button code's declaration is changed to Public, then:

Call UserForm1.CommandButton1_Click

---
Regards,
Norman



"Ben" wrote in message
...
Hi all,

I have button on a form. There's event code in the button click event.
But
when certain conditions are met, I would like to call the button's click
event code. I know that I can take the code out of the click event and
just
write a separate routine and have the click event call that routine, so
that
I can also call the same routine when my conditions are met. But it's not
my
code, so, I would like to just call the click event if possible. Any
suggestions? Thanks.

Ben

--