VB code to run macro?

[Tdp]

I have a userform with a commandbutton1.
I have recorded a macro which I would to run it when commandbutton1 is
pressed.

 

[Per Jessen]

Hi

Copy the desired code without Sub... / End Sub statements.

Select your userform in the VBA editor and right click on commandButton1,
select "view code". The code window for your userform will show:

Private Sub CommandButton1_Click()

End Sub

Paste your code between theese two lines.

Regards,
Per

 

[CmK]

Double click on the button and copy the recorded macro into it

Cheers

 

[Tdp]

Sorry guys,
Its the other way round I'm after.
I have the code in the userform but I wish to move the code to a module,
name it macro1 and then in the userform code under commandbutton1 I want to
write a code to run macro1.

 

[Tdp]

Hi Andrew,
is the second code to be placed in a module?

 

[ShaneDevenshire]

Hi,

If the sub routine MyMacro is in a regular module and is not Private, that
means its name is

Sub MyMacro()

not

Private Sub MyMacro()

Then the code attached to CommandButton1 in your user form is simpy

Private Sub CommandButton1_Click()
myMacro
End Sub