Warning / Error alert

Thanks mate, that is exactly what I wanted!!!

Thanks for all your help!!!

Originally Posted by dominicb

Good afternoon deanJ

Your post's a bit unclear. If someone selects any row in column l (that's L) you want a warning flashed up - is that correct?

If so use this code :

Please Login or Register  to view this content.

Right click your sheet tab and select View Code.
Then copy the code above into the window that opens.
Go to File > Close and Return to Microsoft Excel.

HTH

DominicB

What about if you want to select column 4 and 5 to have the warning pop up?

Hi. You would simply add the additional conditions.

Please Login or Register  to view this content.

Or you can shorten it up a little bit:

Please Login or Register  to view this content.

Thanks for all your help. You have all been great!

Hello folks,

I was thinking of how else this could be written, Withough the use of mutit IF's, Loops & Or.

I though an array though couldnt see how to do it within these constraints, I came accross a missues of the Scripting.dictionary.

Does anyone know of any other ways that this could be coded.

Please Login or Register  to view this content.

DeanJ sorry about putting somethink like this in your thread. (I wouldnt use this code bud).