CODEWITHSUNDEEP
excelvba
Onur
Onur

Reputation: 145

Trigger VBA macro as soon as data validation drop down list is opened?

Is it possible to trigger a macro as soon as a data validation drop down list is opened? (not selecting any value)

Upvotes: 2

Views: 1458

Answers (1)

teylyn
teylyn

Reputation: 35915

AFAIK, Excel VBA does not have an event that triggers when a data validation drop-down is merely opened. The closest Excel VBA events would be the

  • Worksheet_Change event, which could be set to trigger when a value from such a data validation drop-down is selected, or the

  • Worksheet_SelectionChange which would trigger when a cell is selected. The event code can narrow down if the desired cell has been selected, but any code would run merely upon cell selection, not waiting for the data validation drop-down to be engaged.

Upvotes: 1

Related Questions