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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

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?
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." )