Help with incrementing Spinbutton value.

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Help with incrementing Spinbutton value.

FAQ

Thread Tools

Display Modes

11-23-2013, 11:15 PM

macropod

Windows 7 32bit Help with incrementing Spinbutton value.

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,343

I'd have thought you could use something like:

Code:

Private Sub SpinDays_SpinDown()
With Range("D4")
  If .Value = 0 Then Exit Sub
  .Value = .Value - 1
End With
End Sub
 
Private Sub SpinDays_SpinUp()
With Range("D4")
  .Value = .Value + 1
End With
End Sub

PS: When posting code, please use the code tags. They're on the 'Go Advanced' tab.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Tags

activex control, increment value, spinbutton

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
multiply by incrementing by 5s	marynomore	Excel	2	03-27-2013 05:36 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:29 PM.