Assign Macro to Command Button

[ProjectUser]

I’ve created a fairly simple macro that I’d like to assign to a command
button.
Here’s the code I’ve used, but has failed on me.
Private Sub CommandButton1_Click()
Dim mac As Application
mac.Macro “Show Value"
End Sub
Can someone help me with this error?
Thanks.

 

[Jim Aksel]

Assume the existance of a Macro called "ShowValue"

Public Sub ShowValue()
'Any code you want
End Sub

On your user form:

Private Sub CommandButton1_Click()
ShowValue
End Sub





--
If this post was helpful, please consider rating it.

Jim

Visit http://project.mvps.org/ for FAQs and more information
about Microsoft Project