View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Click Event taking time

Hi Bill,

Probably waiting for a non existent double click event. Try using the
mouseup event.

Private Sub CommandButton1_Mouseup(ByVal Button As Integer, _
ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)

Static i As Long
i = i + 1
Caption = i
End Sub

Regards,
Peter T

"William Benson" wrote in message
...
Excel 2003: I have buttons on a userform which have very simple code
attached. I am finding that clicking from one to the next, the second

button
does not fire if I click in modestly quick succession. This will be a pain
to my user, who is trying to enter numbers like clicking on a calculator
pad.

Is there a way to get successive click events to fire more rapidly? For
these buttons, the only activity in the click event is to append the

numeric
they clicked to a textbox's value, like the calculator ap.

Thanks.

Bill