Conditional Pop Up Messages

[Tresfjording]

Hi ...
Been searching for a while, but can't find a solution.
Hope this is the right place.

I have to check a cell (FD20) for three conditions on the cell value.
It' either 19 (which is correct), or below or above (which is wrong)

I have tried the simple approach to begin with, like this:

Please Login or Register  to view this content.

When changing the value of cell FD20 either above og below 19, nothing happens.

I now understand that this VBA thing is beyond my abilities.
But can someone help me out here?

[BadlySpelledBuoy]

I think what you need is a worksheet change event so the code is run each time cell FD20 is changed.
Something like this pasted into the code module (right click the tab name and select "View Code" then paste it in there) should work.

Please Login or Register  to view this content.

Note this will only work when you manually update the cell, it will not work when the cell is updated via a formula recalculation.

BSB

[Tresfjording]

Note this will only work when you manually update the cell, it will not work when the cell is updated via a formula recalculation.

BSB

Ahh, That's why ... thanks.
I must look for other solutions then ...
Any idea?
--Tresfjording--

[AliGW]

You could do this with a formula such that text appears in an adjacent cell, e.g.

=IF(FD20<>19,"Numbers Missing!","")

You can colour the text red and embolden it for visibility.

[BadlySpelledBuoy]

There are different types of events you can use.
The code below will evaluate cell FD20 when a change is made to the worksheet that causes a recalculation.

Please Login or Register  to view this content.

This may not be ideal for your purposes, but without more detail on what you're trying to achieve and why I cannot give a better solution.

BSB

[mikerickson]

Excel's built in Data Validation will do this for user entered values.