Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have cell K3 that is linked to a combo box. When the user picks a
value out of the combo box K3 changes to that value. I need to run code when the value of K3 changes. I have the following code: Private Sub Worksheet_Change(ByVal Target As Range) ' Application.EnableEvents = False On Error GoTo ws_exit If Not Intersect(Target, Range("K3")) Is Nothing Then Hide_RowsPoochPad End If ws_exit: Application.EnableEvents = True End Sub The worksheet_change event does not fire when the user selects an item from the combo box and the value of K3 changes. What do I need to do to get the code to run when the value of K3 changes? I tried using the combo box change event but that will not suit my needs. Thanks, Brent |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
What cell caused the worksheet change event | Excel Programming | |||
Using linked cell to change value in combo box | Excel Programming | |||
Cell value change to trigger macro (worksheet change event?) | Excel Programming | |||
Change Cell from Validated List Not Firing Worksheet Change Event | Excel Programming |