Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
i have a data validation with a drop down list, and
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = Range("d2").Address Then Range("d5").Value = Range("b1").Value Range("f5").Value = Range("c1").Value Application.Run "changesquare" End If End Sub however when i drop down the list and select a different value nothing happens any ideas? thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I change a drop down list? | Excel Discussion (Misc queries) | |||
how do I change graphics from a drop list? | Excel Discussion (Misc queries) | |||
change info in other cells when i change a number in a drop list? | Excel Discussion (Misc queries) | |||
How do you change a drop-down list in Excel? | Excel Worksheet Functions | |||
How to change fonts in drop down list | Excel Discussion (Misc queries) |