LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 16
Default Worksheet change event with cell linked to combo box result

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
What cell caused the worksheet change event Keith Excel Programming 4 October 31st 06 04:02 PM
Using linked cell to change value in combo box eugene Excel Programming 2 May 9th 06 05:21 PM
Cell value change to trigger macro (worksheet change event?) Neil Goldwasser Excel Programming 4 January 10th 06 01:55 PM
Change Cell from Validated List Not Firing Worksheet Change Event [email protected] Excel Programming 3 October 4th 04 03:00 AM


All times are GMT +1. The time now is 07:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"