Spin button

S

Steve

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
 
J

John Bundy

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hidding buttons 3
Locking Cells 1
Auto insert 2
How do you hide ..... 2
VBA time and date? 1
reset a cell 5
Transparent button 5
Command button 2

Top