Trigger data validation from worksheet change event

Just like the title says. I've read numerous posts on how to trigger a worksheet change event upon data validation, but am having a bit of difficulty trying to find something going the other way...in relation to creating a data validation cell when a value is placed within an adjacent cell within a table.

e.g. user places value in cell A (to lastrow) which triggers cell B (to lastrow) to a data validation dropdown. I've set A to be a dynamic named range.


Data validation example:

Please Login or Register  to view this content.

Much appreciated

so i have a few questions for you.

i have a sample workbook that is configured to add a validation dropdown to column B if Column A value is greater than 0.

but that is all it does, so you type a 1 in a cell in column A and in the same row but column B it displays a dropdown list.

is that what you wanted? is yes, then i will upload the workbook.

Thank. I'm sure that would work. If you want to just send me the code, that would be ok too. The value (A) is string, but since the validation only occurs when a value is entered into A, I could equate another range with an IFTHEN >0 statement when A is not null and configure the validation to that working range.

ok, put this in the sheet that you want to monitor:

Please Login or Register  to view this content.

and put this in module 1:

Please Login or Register  to view this content.

also make sheet2 and put in A1 to A5 "1", "2", "3", "4", "5". That is what the validation list references.

ill upload the workbook too just in case you need it.

Thanks dmcgov. Very helpful.

if this fixes your issue please mark the topic as solved (Thread Tools->Mark as Solved) and then click on "Add Reputation", that is always helpful for me.

I thought I had clicked, but let me know if it didn't go through (if you can). By simply removing the cases, it works when a any value (numerical, string) is entered. The validation remains if the cell is null or entire row is deleted however.

I checked and no apparently the click on Add Reputation did not go through, not the end of the world.

post what you have and i will tweak it to clear out that cell.

Yeah, boards been timing out and wanting me to keep logging back in every minute so not sure what the issue maybe. I'll give it a go again. Least I could do for your help.

Please Login or Register  to view this content.