You will need to go msgbox("MyfirstMacro", vbyesno)

"Ollie" wrote in message
...
I have created a macro that gives me a message box when it is run.
Sub MyMacro()
MsgBox "My First Macro"
When I run it I get a message box that only has 1 option in it "OK"

Is there a way to create one that will give me a "Yes" or "No" message