Worksheet Change Problem

P

Pflugs

I am trying to write an event to change the value in a cell after the cell
above it is changed to a certain value. Both cells are validation lists, and
the lists in the second cell are dependent on the value in the first cell.
All the rest of the data in the sheet (thousands of cells) are related to
these cells, and it seems that this recalculation stops the change event.

The code:
Private Sub Worksheet_Change(ByVal Target As Excel.Range)

If Target.Address = "$B$1" Then
Application.EnableEvents = False
Application.Calculation = xlCalculationManual
If Target.Value > 30 Then
Range("B2").Value = "Fillet Root Side"
End If
Application.EnableEvents = True
Application.Calculation = xlAutomatic
End If

End Sub

The code works great on a test sheet. I can't understand why it doesn't
work in the sheet with all the data. Can anyone provide a solution or
workaround?

Thanks,
Pflugs
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top