Ryan

I do not completely understand your program. I tried to put the code in worksheet 3 and the value changed from a buy to neutral (in column B), there was no alert or msgbox whatsoever. Just in case to make if I am missing something I will make it clearer, the column looks like this :

Col. A Col. B
MSFT BUY
GOOG SELL

The cells in col. B updates itself through the New York stock exchange via a DDE Link. So it feeds in data automatically (every single second).

Now the buy can change to Sell at any point of the day during market hours. I want the alert to tell me immediately the price changes.

Now this alert should come to me even if I am working on Worksheet 1.

Hope this helps

Thanks
Devesh



Ryan H wrote:

Put this in the Worksheet 3 Module.
06-Jan-10

Put this in the Worksheet 3 Module. Here you are using the Sheet3 Change
Event which will fire each time any cell is changed in the worksheet. The
Target is the cell that was changed. The code tests if the Target is located
in Col. B and if it is then the message box will show. Hope this helps! If
so, let me know, click "YES" below.

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Column = 2 Then
MsgBox Target.Offset(0, -1).Value & " changed to " & Target.Value,
vbInformation
End If

End Sub
--
Cheers,
Ryan


"Dave" wrote:

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
ASP.NET: Prevent Default Frameset on Refresh or F5
http://www.eggheadcafe.com/tutorials...t-default.aspx