Previous Topic Next Topic

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

Answer 1 / 1
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(......)
3
dmc
Apr 14, 2010 at 02:56 PM
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
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." )
0

Similar discussions

cannot save attachment for yahoo email
joesoui -
nisva -

1 response
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses