how to create a automatic popup alert window

B

bbxxkk

New Member
Joined
Oct 22, 2009
Messages
6
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!
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
Sort by date Sort by votes
bbxxkk said:
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!
Click to expand...

Hi bbxxkk,

Have you tried "Worksheet_SelectionChange" since this event will be triggered after "Worksheet_Change" event, and this event is triggered is there is a changes in specific range object.

-sea-
 
Upvote 0
Welcome to the Board!

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.
Click to expand...

It's not that difficult to limit a change or calculate event criteria to only meet a certain event/value. But you'll need to post the code you have now and what the criteria is in order to have someone adjust it. ;)
 
Upvote 0
thx for ur reply. the problem is that i don't have an idea of how to do this. the spread sheet is taking real time data and those value changes don't trigger the worksheet_change event. what i suppose to do about it?
 
Upvote 0
Smitty said:
Welcome to the Board!



It's not that difficult to limit a change or calculate event criteria to only meet a certain event/value. But you'll need to post the code you have now and what the criteria is in order to have someone adjust it. ;)
Click to expand...

cell A1 Takes real time price

Private Sub Worksheet_Change(ByVal Target As Range)
Dim AlertRange As Range
Set AlertRange = Intersect(Target, Range("$A$1"))
For Each AlertRange In AlertRange
' set up the criteria
If AlertRange.Value < 166.5 Then
MsgBox "alert"
End If
Next

End Sub
 
Upvote 0
You must log in or register to reply here.

Similar threads

T
  • Question
Pop Up Message if specific cells are greater than other specific cells
Replies
5
Views
392
tabs1063
T
S
  • Question
Need code that adds multiple new rows to table to include a check box in column "L" for each new row
Replies
0
Views
325
sspatriots
S
N
  • Solved
VBA Excel opens Word - Split Screen to Windows Planes
Replies
5
Views
644
NdNoviceHlp
NdNoviceHlp
Agnarr
  • Question
VBA problem with creating new sheets
Replies
0
Views
345
Agnarr
Agnarr
F
  • Solved
Automatic margin/profit calculator VBA
Replies
9
Views
974
Micron
M

Forum statistics

Threads
1,214,918
Messages
6,122,257
Members
449,075
Latest member
staticfluids

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top