View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
[email protected] paul.robinson@it-tallaght.ie is offline
external usenet poster
 
Posts: 789
Default How to execute a CommandButton_Click macro without clicking on

Cool
I knew public variables in form code are properties of the form, but
this never occured to me.
Paul

On Mar 22, 6:50 pm, "RB Smissaert"
wrote:
Do:

Public Sub CommandButton1_Click()

Then you can do:

UserForm2.CommandButton1_Click