Microsoft Office Forums - View Single Post - Cell equal value new value of active cell which is a drop down

BobBridges · 04-13-2020, 07:54 PM

I don't use drop-downs much, so I may be wrong. But I think what you want for this is the Worksheet_Change event. When the user first clicks on a cell with a drop-down, the selection changed, so your first program works. But when the user changes the drop-down selection, the selection is still the same cell, but the value changed.