Worksheet spin button with slow startup

PrgmMe

New Member
Joined
Dec 10, 2010
Messages
3
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.
 

Some videos you may like

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

jrosen1040

New Member
Joined
Jan 19, 2011
Messages
2
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

Board Regular
Joined
Jan 18, 2015
Messages
213
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
 

Watch MrExcel Video

Forum statistics

Threads
1,099,077
Messages
5,466,473
Members
406,484
Latest member
kaksolver

This Week's Hot Topics

Top