Msg Box Activates on any cell only want on specific cell

[takisis666]

I want to have a msg box popup if a condition is not met but still have the worksheet protected. When I click on any cell the msg box comes up instead of only on the specific cell.

Here is my code:

Please Login or Register  to view this content.

[Paul]

Hi Takisis,

Please take a moment to read the forum rules, and then edit your thread to wrap your code within CODE tags. For example:

[CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE]

will appear as this when done properly:

Please Login or Register  to view this content.

[MarvinP]

Hi takisis666,

I"m not sure you want this logic statement:

Please Login or Register  to view this content.

Try instead

Please Login or Register  to view this content.

My bad logic sensor alarmed with a not or not.

Hope that helps.

[DonkeyOte]

I suspect you're saying you want something like:

Please Login or Register  to view this content.

[takisis666]

Sorry posted the wrong code. Here is the original code:

Please Login or Register  to view this content.

[DonkeyOte]

The code I posted was wrong anyway... see if below does what you want:

Please Login or Register  to view this content.

if you have more terms to account for there are better methods

[takisis666]

That worked part way, but I need it to check the cell to see if it is equal to the 2 values and if it is not then display the message box and keep the range specified in the original code locked.

[takisis666]

Can someone please help me with this?

[DonkeyOte]

That worked part way, but I need it to check the cell to see if it is equal to the 2 values and if it is not then display the message box and keep the range specified in the original code locked.

Which is what that code does, no ?

Note: VBA by default is case sensitive - so if you're able to enter values in E38 in mixed/lower case you should adjust the code accordingly (ie remove the sensitivity)

If you can't get it to do what you want please post a sample with code in place so we can see in action.

[takisis666]

Here is the file with the code so that you can see what it does.

[DonkeyOte]

Right - but the code suggested is not in the file...

That said there's a typo in my suggestion booLock should of course be boolLock - when you replace your code adjust accordingly

[Paul]

::cough cough Option Explicit cough cough::

[DonkeyOte]

...the code had never made it to VBE I'm afraid so not an OE in sight !

(my bad - again)