Message box pop-up with button

[skier87]

Hello All,

I am trying to make a conditional message box pop up with 2 buttons as options to click:

1. Send email
2. Cancel

Option 1 should evoke the following (unless you know of a better way to accomplish this task):

Please Login or Register  to view this content.

End Sub

I am not exactly well-versed on macros. Any help would be greatly appreciated.

Thank you.

[Leith Ross]

Hello skier87,

Welcome to the Forum!

Since the choice is to send an email or not, you can add the buttons "Yes" and "No" the message box. Here is how...

Please Login or Register  to view this content.

[skier87]

--------------------------------------------------------------------------------
Thanks a lot, this works perfectly!

I would like to edit the conditions for the popup message. Here is what I am trying to do:

- I have a row of numbers 1-31, resembling a calendar.
- Beneath each number, the user may enter '1' or leave it blank.
- If there are more than 2 events (1's) marked in any given 15-day period (within the same month), the pop-up will be displayed asking the user to send the email.

Here is my idea:

- Set the popup conditions to be based on several ranges encompassing the entire calendar month

For example, include several ranges in the code instead of just B4:P4, which are the cells below days 1-15. So, it would be B4:P4, C4:Q4, D4:R4, etc...

Please Login or Register  to view this content.

The problem is that I cannot seem to get multiple ranges to work properly. Usually I end up with too many popup messages coming up all at once, or they come up even when the conditions are not met.

Hope that makes sense. Feel free to change it up entirely if you think there is a way to do this which makes more sense.

Thanks!