Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Choose box, put cell contents, update
I have a drop down box that user chooses from this in turn place a 1, 2, 3 in
L11. At this point I want the code below to run placing the result in G6. However, I have to physically go to cell L11, F2, enter to make it update. How do I get G6 to update automatically after selection of choose box. Thanks Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$L$11" And Target.Count = 1 Then If (Target.Value) = "1" Then Range("G6") = "Cat" End If End If If Target.Address = "$L$11" And Target.Count = 1 Then If (Target.Value) = "2" Then Range("G6") = "Dog" End If End If If Target.Address = "$L$11" And Target.Count = 1 Then If (Target.Value) = "3" Then Range("G6") = "Fish" End If End If End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update cell contents based on worksheet name | Excel Discussion (Misc queries) | |||
Macro to update contents of cell | Excel Programming | |||
Can I use cell contents to update footers in excel? | Excel Discussion (Misc queries) | |||
How do I update contents of activeX combobox? | Excel Programming | |||
Update - Include cell contents in filename automatically | Excel Programming |