Pop-up message box help in Excel 2007

Closed
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-


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.

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
the code for popup is

msgbox(......)
3
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?
0
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Some thing like this

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