Data Validation

**Mike1989** · 09-13-2019, 05:28 AM

Hi..

I am looking for some help if at all possible

I want to do some data validation based on a cell's current value.

Basically if the cell states "Available" it can be edited, if it doesn't state "Available".. it can't.

It seems that data validation doesn't like cells referencing themselves.

Is there any other way this is possible?

Thanks,
Mike

**TMS** · 09-13-2019, 06:56 AM

Think you would need VBA to do that. Selection change event handler to store the current value in a global variable and a Change event handler to check it and allow or disallow changes.

Data Validation

LinkBack

Thread Tools

Rate This Thread

Display

Data Validation

Re: Data Validation

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] VBA to Prevent Data Entry in Cell with Data Validation List - Two Criteria Validation

Restrict data validation list selection based on another table - dependent data validation

Multi-select from data validation isn't working with auto-assigning data validation

data validation lists that are determined by a previous data validation list selection

[SOLVED] Data Validation: How to clear/delete the content of the cell and not Data Validation List?

Data validation choice in one cell FORCES entry from data validation list in another

Using Defined Names with Data Validation Depend and Data Validation Multi Select

Bookmarks

Bookmarks

Posting Permissions