Excel 2007 Create a Pop Up Alert if limit is exceeded

KJ2607

New Member
Joined
Aug 28, 2013
Messages
36
Hi!

I'm creating a spreadsheet to calculate the total travel time between various destinations - I have already set up conditional formatting so if the total travel time exceeds 2 hours for example - the cell will turn red.

What I want to do now is create an alert that will appear when the 2 hours are exceeded informing the user not to proceed.

I've done some looking online and while there is a lot of topics surrounding this I cant seem to find quite the right answer to my query - Is VBA my only option as I am relatively new to this (although learning something new everyday!) :)

Thanks in advance
 

tweedle

Well-known Member
Joined
Aug 1, 2010
Messages
1,559
Hi!

I'm creating a spreadsheet to calculate the total travel time between various destinations - I have already set up conditional formatting so if the total travel time exceeds 2 hours for example - the cell will turn red.

What I want to do now is create an alert that will appear when the 2 hours are exceeded informing the user not to proceed.

I've done some looking online and while there is a lot of topics surrounding this I cant seem to find quite the right answer to my query - Is VBA my only option as I am relatively new to this (although learning something new everyday!) :)

Thanks in advance
No, VBA is not the only option.
You can use Data Validation to spawn alert messages.

Try this...

Select the cells for which you want to show the error.
Then
Menu: Data/Data Tools/Data Validation


On the Under Settings tab:
Allow Decimal
less than or equal to
2.0


On the Input Message tab:
Un check the "Show input message when cell is selected"


On the Error Alert tab:
Check the "Show error alert after invalid data is entered"
select the Style you prefer [Note: Different styles have different buttons for user input]
Give it a Title and Error Message


OK
 

KJ2607

New Member
Joined
Aug 28, 2013
Messages
36
That's excellent Thanks!! :)

I've now split my columns up into days so I have a journey start time (cell A1), journey end time (cell A2) for monday , and then a journey start time (cell A5) and end time (cell A6) for Tuesday and so on. I need to have a 12 hour break between the end time on Monday and the start time on Tuesday and if there is less than 12 hours, the alert message will appear.

Where does the formula go?
 

tweedle

Well-known Member
Joined
Aug 1, 2010
Messages
1,559
I spouted off too soon.

Data Validation won't pop on calculated cells, only user entry; and time calcs are different as they convert to the decimal portion of the difference between date/time, so a 12 hr period is .50 in Excel terms.

Soooo, vba may be the way to go for an alert/pop-up.
 

Jim885

Well-known Member
Joined
Jul 8, 2012
Messages
625
KJ,

It would be best if you put all your requirements together before asking for assistance, as well as provide an example of your spreadsheet or the desired result so that we have something to visualize. That way, you don't waste someone's time.

Hope this helps you understand.
 

Forum statistics

Threads
1,082,601
Messages
5,366,571
Members
400,902
Latest member
fathima

Some videos you may like

This Week's Hot Topics

Top