Hi all,
I'm keen to get some help in VBA that will clear the selection in the area column (B) if the state in column (A) is changed...
eg:
State selected: QLD, Area selected is Brisbane, however if someone changes the state to NSW, Brisbane selected in Area column should auto remove (as Brisbane is not an area in NSW), I was able to find one in a thread in Google but it clears all cells in the column instead of that one cell
Any help would be greatly appreciated - Thank you!
View attachment Dependant Drop Down.xlsm
I'm keen to get some help in VBA that will clear the selection in the area column (B) if the state in column (A) is changed...
eg:
State selected: QLD, Area selected is Brisbane, however if someone changes the state to NSW, Brisbane selected in Area column should auto remove (as Brisbane is not an area in NSW), I was able to find one in a thread in Google but it clears all cells in the column instead of that one cell
Any help would be greatly appreciated - Thank you!
View attachment Dependant Drop Down.xlsm