Spin button  
Author Message
Rowdyron





PostPosted: Wed Jan 16 08:24:54 CST 2008 Top

Excel Programming >> Spin button

Hiya

How do you use the spin button? Arrow up arrow down ... hmm could be
useful. Anyone got a quick tutorial on increasing and decreasing a cell by
+1 and -1 ?

Thx

Steve


---
avast! Antivirus: Outbound message clean.
Virus Database (VPS): 080116-0, 16/01/2008
Tested on: 16/01/2008 13:47:34
avast! - copyright (c) 1988-2008 ALWIL Software.
http://www.hide-link.com/

Excel14  
 
 
Bernard





PostPosted: Wed Jan 16 08:24:54 CST 2008 Top

Excel Programming >> Spin button Have a look at:
http://support.microsoft.com/kb/291073
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email



> Hiya
>
> How do you use the spin button? Arrow up arrow down ... hmm could be
> useful. Anyone got a quick tutorial on increasing and decreasing a cell by
> +1 and -1 ?
>
> Thx
>
> Steve
>
>
> ---
> avast! Antivirus: Outbound message clean.
> Virus Database (VPS): 080116-0, 16/01/2008
> Tested on: 16/01/2008 13:47:34
> avast! - copyright (c) 1988-2008 ALWIL Software.
> http://www.avast.com
>
>
>


 
 
jmbundy





PostPosted: Wed Jan 16 08:29:02 CST 2008 Top

Excel Programming >> Spin button It is VERY simple to use, place it on the sheet and double click it. It
selects change by default, you will want to use the dropdown at the top right
to select spinup or spindown. Here is a sample to increase or decrease cell
A1 by 1

Private Sub SpinButton1_SpinDown()
Cells(1, 1) = Cells(1, 1) - 1
End Sub

Private Sub SpinButton1_SpinUp()
Cells(1, 1) = Cells(1, 1) + 1
End Sub
--
-John
Please rate when your question is answered to help us and others know what
is helpful.




> Hiya
>
> How do you use the spin button? Arrow up arrow down ... hmm could be
> useful. Anyone got a quick tutorial on increasing and decreasing a cell by
> +1 and -1 ?
>
> Thx
>
> Steve
>
>
> ---
> avast! Antivirus: Outbound message clean.
> Virus Database (VPS): 080116-0, 16/01/2008
> Tested on: 16/01/2008 13:47:34
> avast! - copyright (c) 1988-2008 ALWIL Software.
> http://www.avast.com
>
>
>
>