Now for my next problem. I have created the following msgbox:
Public Sub OkButton_Click()
MsgBox "Would you like to price another gasket?", vbyesNo
......how do I define whether or not yes or no are selected?
I ultimately would like "yes" to reload userform1 again and "no" to close the workbook ( or excel altogether ). I am frustrated now as this should be easy.
This is what I have tried....please let me know what I'm doing wrong so I can learn ( I am a complete newbie on day 2 of VBA )
If ("MsgBox = vbyes") Then userform1.show
If ("MsgBox = vbno") Then activeworkbook.close savechanges:=true
Thanks for any help you can give me