3 times on_change if triggered to excel

[Guentschi]

I have a problem with the on_change in Excel.

The only code is:

Private Sub Worksheet_Change(ByVal Target As Range)
MsgBox ("Change")
End Sub


I set the refresh rate to 20 secs. I get the messagebox three times every twenty seconds. Does anybody have the same problem, or what am I doing wrong?
I have the problem in Windows Vista and Windows XP.

With best regards
Guenter

[Guentschi]

I forgot to mention.
I have BA ver 1.1.0.14 Beta

Thanks

[GaryRussell]

It is because the worksheet is updated by Betting Assistant in 3 operations. You can limit your code to only execute on one of these updates by checking for the number of columns updated which is 16 when the prices are updated, example below.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Columns.Count = 16 Then
MsgBox "Change"
End If
End Sub

[Guentschi]

Thanks for the quick reply.

Guenter