Excel 2007 vba Worksheet_Change not updating from dropdown Cell link -


i have vba code in excel 2007 (also needs work in 365).

private sub worksheet_change(byval target range)      if target.address = "$v$6"         msgbox "here"     end if end sub 

if cell v6 manually changed (e.g. key in number) msgbox displayed. when dropdown updates cell msgbox not displayed. can't see how dropdown updating different.


Comments