Command Button Macro Link

[newclasshero]

I am having trouble with Assigning a Macro to a Command Button. Being new I think there may just be something simple that I am not doing. I have the Command Button in the appropriate spot on my sheets and I have the right macro created already but I can't seem to link the two. My Macro name is: VOUCHER_DriverExpenses.

The code is:

Sub CommandButton1_Click()
Call VOUCHER_DriverExpenses
End Sub

When I attach the above code to the control button and hit the button I get an error message.

I can run the macro just fine on it's own.

Any help would be appreciated.

 

[newclasshero]

oh and PS. Wanted to use the command button becuase I can change the properties.

 

[Smitty]

What's the error message?

Smitty

 

[newclasshero]

It says

Compile Error:
Sub or Function not defined.

 

[Norie]

Where is the code for VOUCHER_DriverExpenses located?

 

[Smitty]

Duh,

I completely overlooked the fact that you're missing "Private" in the Sub line.

It should be

Private Sub CommandButton1_Click()

Smitty

 

[newclasshero]

I am sorry I have tried to do it with the Private Sub but to the same results (ie. Error Mesage). The macro is stored in the PERSONAL.XLS file.

 

[newclasshero]

I am sorry I have tried to do it with the Private Sub but to the same results (ie. Error Mesage). The macro is stored in the PERSONAL.XLS file.

 

[newclasshero]

Thank you for your help. It took alot of playing with it but it works now.