CommandButton Macro

[srizki]

Good day every one,

I want to assign a macro to a commandbutton, that should say, for example, "DO NOT PRINT" when the button is clicked or whatever message I assign. I need a standard code, so I can chage it accordingly.

Thanks

<!-- Converted from text/rtf format -->Sohail Rizki

 

[mikerickson]

Insert a button from the Forms menu.
When it asks to Assign Macro, click NEW and then use this macro

Sub Button1_Click()
    MsgBox "Hello"
End Sub

 

[VoG]

Try with a button from the Controls toolbar (ActiveX control)

Private Sub CommandButton1_Click()
MsgBox "Do not print", vbExclamation
End Sub

 

[srizki]

Thank you very much to both of you.