Hi all,
Looking to run a macro when any cell is changed in range D3:D5 via drop-down box. Currently the cells are set to "select" as default text but the user has the option of choosing choosing a value from 1 - 10.
test file attached.
thinking the code to go something like this
Option Explicit Private Sub Worksheet_Change(ByVal target As Range) If target = Range("D3:D5") Then If cell changes, <> "Select" execute another macro end if
Bookmarks