Pop-up message box help in Excel 2007

Closed
dmc - Apr 14, 2010 at 10:36 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 14, 2010 at 03:22 PM


Good morning, I am trying to create a pop-up box in Excel using VBA. I have to admit I have only created simple macros before. Right now I have an "if" statement to compare two dates to see if they are more than 60 days apart and if yes an error message of sorts shows in the cell.

I would rather have a pop-up box that gives the error message and that the user would need to click 'ok' to have it go away.

Can anyone help?

P.S. I did write some code but I kept getting error messages I could not figure out.

Thanks.
Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Apr 14, 2010 at 10:46 AM
the code for popup is

msgbox(......)
I did get that far -- what I kept getting error notices on was how I put in the message.

"Your entry is past 60 days -- please note payment could be refused." When I put that in VBA kept giving me error messages.

Can you help with that?
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Apr 14, 2010 at 03:22 PM
Some thing like this

Msgbox("Your entry is past 60 days -- please note payment could be refused." )