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
Post a Comment