Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet SelectionChange event
Hi, I have the following bit of code attached to a worksheet object:
Private Sub Worksheet_SelectionChange(ByVal Target As Range) On Error Resume Next If Target = Range("job_no") Then Application.ScreenUpdating = False Worksheets("summary").Calculate Call ...MyCode..... Application.ScreenUpdating = True End If End Sub This works fine when the cell called "job_no" is selected or changed, however it also runs when some other cells, (but not all), containing just text, no formulae, are also changed. Can anyone suggest what may be happening. I only want it to run if the "job_no" cell is changed/selected. Usual TIA Rgds |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to use selectionchange instead of doubleclick event? | Excel Discussion (Misc queries) | |||
Worksheet SelectionChange Event | Excel Discussion (Misc queries) | |||
Disable SelectionChange Event | Excel Discussion (Misc queries) | |||
SelectionChange event | Excel Programming | |||
SelectionChange Event | Excel Programming |