Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / January 2008

Tip: Looking for answers? Try searching our database.

Spin button

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Steve - 16 Jan 2008 13:44 GMT
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
Bernard Liengme - 16 Jan 2008 14:24 GMT
Have a look at:
http://support.microsoft.com/kb/291073
best wishes
Signature

Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

> Hiya
>
[quoted text clipped - 12 lines]
> avast! - copyright (c) 1988-2008 ALWIL Software.
> http://www.avast.com
John Bundy - 16 Jan 2008 14:29 GMT
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
Signature

-John
Please rate when your question is answered to help us and others know what
is helpful.

> Hiya
>
[quoted text clipped - 12 lines]
> avast! - copyright (c) 1988-2008 ALWIL Software.
> http://www.avast.com
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.