Email:      Pass:    Pass?
Close Window   
TE
Free Excel Tips in Your Email!
Join Over 20,000 Happy Subscribers!
E-mail:
Subscribe for Free Excel tips & more!
E-mail:


Advertisements


Free Excel Forum

Creating Alerts!or Popups In Excel

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

hello!!!
is it possible to create a popup or alert message if any one of the cell meet condition with in the range of cells.

thanks
surya

View Answers     

Similar Excel Video Tutorials

Helpful Excel Macros

Pop-Up Message Box When a Range of Cells Reaches a Certain Average
- This macro will display a message box when the numbers within a range of cells reaches an average of 5. The current mac
Pop-Up Message Box When a Cell Reaches a Certain Value or Contains Certain Text
- This macro will display a message box in excel when a cell reaches a certain value or contains certain text. This means
Add an Input Message to a Cell - Message Appears When the Cell is Selected in Excel - Data Validation Macro
- Add data validation input messages to cells in Excel with this free Excel macro. These messages appear when a specific
Create a Line Chart with a Macro in Excel
- Create a line chart in Excel with this macro. This allows you to quickly and easily create line charts and graphs from
Delete Multiple Named Ranges Quickly
- This macro will allow you to delete multiple named ranges very quickly. When you run this macro, a message box will pop-

Similar Topics







Hi, In my sheet there is some stock values.(e.g) Column C, E & G. In"C"column there is
minimum Values, if below the minimum Value the "Pop Up Message" will come as' LOW VALUE".The same way"E"column if value is more than instructed value, the message will PopUp "High Value" & finally"G"column i have to put Three condition, If Value meet the first condition "LOW ", if meet the second condition,"BORDER" & if meet the final condition "OUT OF RANGE". I have add simple Macro in Column "C" only for reference.
The macro should work in C1 to C100,E1 to E100 & G1 to G100.
Thanks for advance


I'm quite new to Excel,
I want to Know, can Excel supports any Pop Up messages...
My question is
I'm storing the customer data, in one of the filed i'm mentioning the due date,
can i write a macro or any other mechanisim which Popups a alert message whenever i open my excel sheet.
Does Excel supports any PopUp Messages mechanism.
Please help me asap

ty in advance...


Sorry if the subject is a bit confusing... Here's what I'm trying to do.

I'd building a stock price alert sheet, much like many others have done on this board. Basically there will be thresholds/triggers, live market data being fed in, and some sort of marker column to indicate when an alert has been triggered (and should be sent to pop-up) and when it has been reset by the user.

The pop-up I'm looking to create (dialog box or userform of some type) should have the following characteristics:

1) Hopefully it won't disable the data feed/auto calcs/other scripts running on my sheet (i.e. if the user doesn't click 'OK' then nothing else in Excel can happen -- this would be a problem)

2) The pop-up is persistent enough that it isn't overlooked by the user, i.e. Always on Top, flashing Excel bar in taskbar, etc. Something to that effect...

3) The pop-up will ideally look more like a list or log, able to house multiple alerts at once. For example, if one alert pops up and the user is away from their desk, and then a second alert appears, I'd like for both to be listed in the alert window. Is something like this even possible? Can I embed part of a worksheet into something like a userform, so that as cells of the sheet are populated they appear in the "pop-up"? If not, I would need the ability to have multiple pop-ups at once (for different alerts being triggered simultaneously or before the previous alert was dismissed).


Hopefully that's a start... I'm fairly comfortable with VBA but can't do much from scratch. I feel like I can figure out how to structure my sheet, autocalc code, markers, etc, but the pop-up is causing some trouble. Any help would be appreciated.


Thanks!


Hello,

I would like some help in creating a VBA Macro that will create a popup message if cell C7 contains text. Cell C7 will populate text depending on a vlookup of a different sheet. The popup message is simple, something like "See Instructions".

Please advise on whether this is possible and what the best way to go about it is. Much thanks in advance.


Hi Guys,

I want to create a Pop-up without buttons in my macro (like outlook desktop alert).
it will show after a process completed when i am working on some other applications like browser, or MS Access.
When I surf for this stuff all forums and websites I've browsed are giving idea only with message box. But I want to create a Pop-up like outlook desktop alert. Can I have a solution for this?

I hope I will have solution.

Thanks.

I'm trying to get Excel to pop up an alert to check if a cell hasn't been filled in. I 've run into a few times where I have not put anything into it, only to get in trouble at work for not having the proper info in it. It doesn't always have data in it, but I want to make sure that it alerts me regardless. Any ideas?


Hello, this query is more for my curiosity than need. I'm using 2007 and Win XP.
What code do I use to answer yes to a popup generated by a macro?
The popup occurs when I move sheets that have a vlookup formula into another workbook that has the same formula.
The popup asks, "YES" or "NO", if I want to use the "NAME" listed in the workbook I'm moving the sheet into.
I've tried to elliminate the "NAME" by replacing it with the range of the array in both workbooks, but it seems to assign the "NAME", the sheet name that has the Vlookup array, automatically.
Thanks, I'll try to answer any questions that may help if you find this specific challenge interesting, but was more interested in a generic type of response to popups in macros.
Kendel


I need some help. Everyone who has posted in these Forums has been incredibly helpful so far. I wasn't able to find any information on this one however.

I have a sheet that alerts me with a message box when a set time has passed. This works fine as long as I have this sheet active. I would also like to get the same alert when I have a different sheet selected.

For example, in Sheet 1, cell A1 I have entered 12:00. If I am on Sheet 1 and it is after 12:00 I get a message box. However, if I am on Sheet 2, the alert never pops up.

Is it possible to have the message box pop up no matter which sheet I am on?


Hello,

I need some help with creating a conditional message box based on formatting. Here's my situation:

I have several cells in my worksheet that are conditionally formatted. These cells turn red if the value in that cell is greater than 20% of the value in the cell above it. I would like to create a message box that alerts the user if there are red cells in the worksheet when the user tries to close the workbook. I tried the following code (based soley on web searches that I did, as I have no VBA experience), but it did not work.

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Dim cell As Range
For Each cell In Range("main_body")
If cell.Interior.ColorIndex = 3 Then
MsgBox "A required field has not been filled in." & vbCrLf & "Please review and re-submit", vbExclamation + vbOKOnly, "Validation"
Cancel = True
End If
Next cell
End Sub

I named the range of cells that would contain the red cells as "main_body."

Any help would be greatly appreciated!

Nisha


hello everybody.
I have an excel sheet that uses data from a html file.when that file stops working I recieve on my excel that I cannot connect to the file.It's all right.After one minute the file starts again transfering.But the problem is that if i do not push the alert button excel will not start again.Is there a way eather to delay the transfer to excel when there is no data (so it will not get the alert) or stop the alert message?
thank you all.


hello everybody.
I have an excel sheet that uses data from a html file.when that file stops working I recieve on my excel that I cannot connect to the file.It's all right.After one minute the file starts again transfering.But the problem is that if i do not push the alert button excel will not start again.Is there a way eather to delay the transfer to excel when there is no data (so it will not get the alert) or stop the alert message?
thank you all.


Hello,

i am trying to create a automatic popup alert window. the window pops up after a certain criteria is reached. for instance, a stock price change not more than x% the alert window pops up.

the problem is that if i use the worksheet_change, or other events because the price change value is calculated by a excel formula, the value change couldn't trigger the event.

any thoughts?

thanks!


Hello.

I have a chart that's being updated with different values when I cklick on different radiobuttons.
When the cells that the radio button refers to is empty or the calculation in the cell have an error it pops up a message that I need to click OK to go on.

Is there a way to stop these alerts by writing a script that shuts the alert messages off during each click?

Anders


Hello All! I need some help with creating alerts in excel with durations. I'll explain.

Let's say we're working with cell A1. When A1>5, I would like another cell to turn to red fill and display a certain text. Well...this is easy enough using conditional formatting and some formula work.

However, what I really need is for the cell that turned red and displayed text to return to its original state after a certain pariod of time has elapsed from the time that A1 became greater than 5. For example, 1 hour, or 1 day after the inital alert.

I think this is possible using timestamps...but I'm not sure how. Any help would be GREATLY appreciated. Thanks!


Hi -

I have a few cells that I have conditional formating to make font bold red if meet. There are too many to look at. Can I make one cell at the top of the page say something that will alert me to look down the list for anything in red bold???

Thank you


Greetings.

I found a bit of code that is doing all but one thing I would like it to. I can't figure out the last part. In column B, I have tracking numbers. Once any cell in column B is selected, there is a popup, followed by the Insert Hyperlink popup. Perfect. The user can click on the hyperlink and everything works as it should, only they still get the two popups. Is there a way to have the popups appear only when they select a cell in Column B that is empty? I hope all that makes sense. Here is my code:

Code:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
With Target
    If .Count = 1 And .Column = 2 Then
        MsgBox "Enter the hyperlink with TEXT TO DISPLAY as the Tracking Number and ADDRESS as the location"
        Application.Dialogs(xlDialogInsertHyperlink).Show
    End If
End With
End Sub





This one doesn't make sense to me.

I'm working on a project using data validated lists. For some, I'm leaving the error alert setting on "Stop", and for others I'm using the "Information" setting to permit entry of something other than the specific list values.

I have a situation where I'm not getting a consistent response from these settings. In some cells, I'll have the error alerts set to "Stop" (and the box checked to show the alert), and I can enter text manually without getting any alert warning. Other cells set the same way on the same page work as they should.

Anyone have an idea why or how this could occur?

I use these data validation feature all the time and have never seen this behavior before. I've tried clearing the cells and re-setting them, with the same results. I don't get it...


Hi,

Others have posted about disabling alerts with VBA when a PivotTable will overwrite cells (http://www.mrexcel.com/archive/Pivot/21007d.html). I want to disable the alert, and prevent the overwrite.

Disabling alerts defaults to an answer of 'Yes' in the case of overwriting cells adjacent to a PivotTable. How can I programmatically force Excel to answer 'No' in the event a warning pop up should appear?

Thanks for the help. First post from a long time reader.




Hi
I have attched a sample workbook,

When the time required for is entered in column J column k counts down the time left to complete the job, the cell goes red with one
hour to go.

is it possible to do the following:-

When the half hour to go is reached warning alert message box is shown and or audio alert is sounded, but if the completed box is selected in column P the alerts are disabled and the time frozen in K ???

Regards


Peter

I am creating a excel spreadsheet that contains expiration dates of contracts. Is there a way to have the excel alert me before the date arrives or maybe just change color to let me know the end date is coming up? I would like to have an alert 2 months prior to the expiration. Any help would be greatly appreciated. I'm a fairly new user of excel 2003.

Thanks!


Hai
I Need a Macro Which will filter & show me a popup message with "Cell Value C - Purchase Order To be Raised" when the following condition is true
1.Cell Value Column L = (65% of E)
2.Cell Value Column M = Yes

I don't want the Popup Message to appear when the Cell Value Column M = No

Regards
Mani


Hello!

I just got a 'subscript out of range' error.
I wanted to make an array which collect all the values from a column that meet the specific conditions.

Here is the code:

VB:

Dim arrThomas() As Variant 'this is my array
 
Dim pozicio As String 
 
 
pozicio = Sheets("Form").Range("F9") 'this is the cell, where I give the condition
 
 'I collect all the values to the array that are meet the condition:
For i = 2 To 2000 
    For j = 0 To 1000 
        If InStr(1, Sheets("Data").Cells(i, 5), pozicio, vbTextCompare) > 0 And InStr(1, Sheets("Data").Cells(i, 6), "scope", vbTextCompare) > 0 Then 'I check the column which cells contain the condition
            arrThomas(j) = Sheets("Data").Cells(i, 2) 'I want to fill the array with the values that meet the condition (here I got the error message)
        Else 
        End If 
    Next j 
Next i 
 
 
End Sub 


If you like these VB formatting tags please consider sponsoring me in support of injured Royal Marines



What did I make wrong?

Thank for your help!

Thomas

Hey everyone!

I would like to be able to create an alert/message which appears when someone opens a specific file. Is this possible?? Ive tried to search MS site but cant find anything.

Although Im considered advanced where I work Im still not 100% with things like VBA so any easy methods would be greatly appreciated.

thanks in advance


Hi All,

I am not so good at VBA coding, so can you help me with this.
I have a question: In excel while we fill data if user skips to enter data in any cell can we pop up any alert message which guides user to fill up empty cells before they proceed to any other cell?

I need alert message for certain columns from column A to I,
R to S,
only U,
W to AC.

and in Column S if we skip to enter data we can either enter in column T
viceversa if we skip to enter data in T should enter data in column S.
i.e data should be entered either in S or T, Cant leave both columns empty.

I need alert message for the entire cells not for a particular range of cells.

I need a alert pop up message soon after the user tries to skip entering data in any cell in excel2003,Using VBA coding is this possible?And i dont require any validation for this.Please suggest any solution with coding.
Solution to this problem would help me a lot...

Any help would be appreciated...
Thanks in advance...
akki83


Hello -

When I click A1, B1, C1, etc. I'd like to have a message box pop up with any notes I have entered into A20, B20, C20, etc. If there's nothing in A20, B20, C20, etc. then I do not need an alert box. Esentially I need something that alerts me that I have notes and need to do something about them. This is a tracking spreadsheet that I am continually forgetting to look at the notes on.

Any suggestions?