| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
On Action?
Thanks, and I did something similar
"CWillis" wrote: I use a list box in a program. When something is selected from the box, a macro is run. Here is the code. I hope this helps: 'This sub runs when cell G7 is changed. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Cells.Count 1 Then Exit Sub If Intersect(Range("G7"), Target) Is Nothing Then Exit Sub Const WS_RANGE As String = "G7" Application.EnableEvents = False If Range("G7").Value = "listboxoption1" Then Range("M7").Value = " " Range("M8").Value = " " ElseIf Range("G7").Value = "listboxoption2" Then Range("M7").Value = "typetexthere" Range("M8").Value = " " ElseIf Range("G7").Value = "listboxoption3" Then Range("M7").Value = "typetexthere" Range("M8").Value = " " ElseIf Range("G7").Value = "listboxoption4" Then Range("M7").Value = "typetexthere" Range("M8").Value = "typetexthere" End If Application.EnableEvents = True End Sub "John" wrote: I want to run a macro after the cell B7 is edited... currently the cell is a DATAvalidationlist Does it need to be a Listbox? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excell copy action pauses for 15 second for the smallest action | Excel Discussion (Misc queries) | |||
| On Action | Excel Programming | |||
| what is an OLE action | Excel Programming | |||
| OLE action? | Excel Programming | |||
Hybrid Mode
