Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.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.avast.com |
#2
Posted to microsoft.public.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 "Steve" wrote in message ... 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 |
#3
Posted to microsoft.public.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. "Steve" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Spin Button | Excel Programming | |||
spin button value | Excel Discussion (Misc queries) | |||
spin button | Excel Programming | |||
Spin Button... | Excel Programming | |||
Spin Button | Excel Programming |