PDA

View Full Version : Pop Messag Box required if value is different



haridevadiga
03-06-2009, 02:52 AM
Dear User,

I have some query regarding the POP MESSAGE BOX....

Problem :

I have two excel file in which i want is:- In both the file if a value in Cell B11 get change i should get a pop up message box


If you not get me see the files.. In Test1 you will fine a value 56 on Cell B11 & in Test 2 you will see a value 55 on Cell B11, I want a pop up message saying tht "PLEASE CHECK THE VALUE"

Warm Regards,
Hari

MaximS
03-06-2009, 03:33 AM
I've added a little bit of code which will compare cells B11 in both workbooks when you open test1. If it's wrong will show msgbox.

Place two workbooks in the same folder and name the other as test2.xls or adjust code to your needs.

See attachment for details.

haridevadiga
03-06-2009, 03:51 AM
Thank You MaximS. Its Working.. :)