Pop up Measage throuh VBA

Hi,

I am new to VBA and want to pop up specific message.

I have an excel sheet where in particular cell values true/False through formulla. I want to pop up meassage if the cell values change to false.

Please help

Thanks Sir

As the change in cell value is caused by a formula you need a two pronged attack. Something like this:

Right click on sheet tab where cell is. For instance sheet1 and click "View Code". In the windows that opens up add this code

Please Login or Register  to view this content.

Then right click on “ThisWorkbook” and paste this code (see image)

Please Login or Register  to view this content.

Save the file and close it and when you open it again the PreVal value is read and will be compared to changes in cell B4

Attachment 645646

Alf

Oh problems uploading image again!!!! Why can't the thech team fix this!!

ThisWorkbook.jpg

Please Login or Register  to view this content.