Excel VBA Macro - Limit based on cell selection

Trying to restrict a user from selecting from anything in 3 columns with a data validation list

Target Range: (three columns L:N) i.e. L3, M3, N3 up to L40, M40, N40.

Unless a user first populates a field in Column U

Target Range: U3-U40

I've tried searching how to lock cell selection unless a corresponding cell is selected for the last few days to no avail. Think the issue is because the target cells aren't actually having a value entered and instead are using a list from conditional formatting.

Thanks! Andrew.

Did you mean a Data Validation list?

To install the code:

• Right-click on the sheet tab.
• Select View Code from the pop-up context menu.
• Paste the code from below in the worksheet's code module.

Please Login or Register  to view this content.

Did you install the code in the Worksheet code module as described, and not in a standard code module like Module1?

It's fairly simple code. Works for me.

I assume you didn't modify the code?

Try saving your workbook, closing, then reopen it.

Hi Andrew,

You haven't used AlphaFrog's code

That said, see how this goes:

Please Login or Register  to view this content.

Regards,

Robert

really starting to wonder what I'm doing wrong

Me too as it's working for me

Are the macros enabled? Is so are they switched on i.e. is Application.EnableEvents set to True?

If so try putting a break point (press F9) on the first line of the Shield and run the code again and see what's happening by then stepping through the code (pressing F8).

I've also included more conditions on the following to only work on columns L to N and rows 3 to 40.

Please Login or Register  to view this content.