Worksheet spin button with slow startup

[PrgmMe]

I'm using Excel 2007 on XP. I have a spin button on the worksheet which is very slow to respond on the first click. The spin button changes some linked variables and that changes the information displayed on the page. I strongly suspect that the first click is resulting in some sort of calculation lag. Subsequent clicks are rapid and don't cause any appreciable delay. Is there a way to make the first click faster? I'm not refering to the single vs. multiple clicks as set on the object control. This is something different - a delay of several seconds, not 50 milliseconds.

 

[jrosen1040]

I know this is 5 years after the original post. I had the same issue and solved by adding following VBA code (assumes the spin button is named SpinButton1:

Private Sub SpinButton1_GotFocus()
Application.Calculate ' this helps speed up response to first click on a spin button
End Sub

 

[Ken Cowen]

I know this is 5 years after the original post. I had the same issue and solved by adding following VBA code (assumes the spin button is named SpinButton1:

Private Sub SpinButton1_GotFocus()
Application.Calculate ' this helps speed up response to first click on a spin button
End Sub

So, now, 2 years after your post, I just used that line to speed up 6 spin buttons on an excel 2016 worksheet that was incredibly slow, for the first click.
Thanks
Ken