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
-----Original Message-----
could you post your code?

--
Don Guillett
SalesAid Software
Granite Shoals, TX

"Kirk" wrote in message
...
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


.

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

--
Don Guillett
SalesAid Software
Granite Shoals, TX

"Kirk" wrote in message
...
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
-----Original Message-----
could you post your code?

--
Don Guillett
SalesAid Software
Granite Shoals, TX

"Kirk" wrote in message
...
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


.