Worksheet Change question

  • Thread starter Thread starter Kirk
  • Start date Start date
K

Kirk

I have code that is executed when the something changes
within the I or J column of my spreadsheet. It works
great more or less. The problem I experience every so
often is after one cell value is changed 3 or 4 times
consecutively (doing it to test functionality), the code
quits executing. Has anyone experienced this? Is there
something that I need to do to ensure that no matter how
many times a user changes a value in one cell that the
code will still execute?

Any info or comments would be appreciated. Thanks.

Kirk
 
Here is the code that is under the Worksheet Change
section:

If Mid$(ActiveCell.Address, 2, 1) = "I" Then
Call UpdStorageLocation
ElseIf Mid$(ActiveCell.Address, 2, 1) = "J" Then
Call UpdStorageLocation2
End If

It works find and dandy the first few times, but it
occasionally does not kick off when a cell changes after
the same cell has been changed 3 or 4 times consecutively.

Kirk
 
Try

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 9 Then Call UpdStorageLocation
If Target.Column = 10 Then Call UpdStorageLocation2
End Sub
 
Back
Top