Cell Value Change Alert

I am new to VBA and need some help regarding some codes. Here is the complete scenario:

I have 3 worksheets:

Worksheet 1 = Master Page
Worksheet 2 = Data 1
Worksheet 3 = Data 2

In worksheet 3 I have got 2 columns. The first column has the name of the companies and the second column has buy and sell signal which is based on certain criteria and this cell updates itself automatically in real time.

I would like to have a VBA Code which just flashes me a messagebox when ever there is some change in Column 2 of Worksheet 3. The message should display the updated value of column 2 (in this case "buy" or "Sell" from Column 2 and also the name of the company from the adjacent Column 1)

The message box should appear as follows:

"Microsoft changed to BUY"

Here Microsoft is actually the value in Column 1 and the BUY is in Column 2 in the same row.

The message box should appear even if I am on worksheet 1 and not on worksheet 3.

I would appreciate if someone can throw some light on my query.

Thanks

Hi Devesh,

I am no VBA expert, however I would like to tell you that you can have conditional formatting do the trick for you instead of having a MsgBox if it just has to display BUY or SELL.

If you still want a VBA solution some experts in VBA would be able to help you but it will be better if you could add your file to get a better idea in both cases..

Warm Regards
e4excel

Thanks for a quick reply. Conditional formatting is already there in the cells so at any given time the cell value can be Sell, Neutral or Buy. I want the msg box to tell me whenever there has been a change from Buy to Sell, Sell to Buy, Neutral to Buy or Neutral to Sell. In short if there is any change in cell value I should be notified.

Since I have more than 500 stocks in that particular sheet, it is not possible for a human eye to track changes in all the stocks at any given time. I would like to have an alert msg box or even something in Worksheet 1 that can show me the stock name with the changes only and not all the stock. Hence at any given time there would be 2-3 stocks that needs my attention and I would like to see only those stocks out of the whole set of 500 stocks.

I hope I have made my query clearer. I apologies for any confusion in my previous post.

Devesh,

Can you please add your Sheet by Masking or putting Dummy Data in order for you to get help..

Im sure if its just adding a Msgbox I can try helping you out personally but after you upload your file there would be several helping hands in the offer..

Warm Regards
e4excel.