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