Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 11-20-2013, 09:51 PM
dlowrey dlowrey is offline Help with incrementing Spinbutton value. Windows 7 64bit Help with incrementing Spinbutton value. Office 2010 32bit
Novice
Help with incrementing Spinbutton value.
 
Join Date: Feb 2012
Posts: 29
dlowrey is on a distinguished road
Default Help with incrementing Spinbutton value.

Problem 1: The cell D4 value increases or decreases by 2 when the spinbutton is clicked. The spinbutton is an activex control named "Spindays".



Problem 2: The value will go below 0 (ex. -1), even though the property Min is set to 0.

What did I miss?

Thanks for your help. The code is below.
- DL

Private Sub SpinDays_SpinDown()
With Range("D4")
.Value = Range("D4").Value - 1
End With
End Sub
Private Sub SpinDays_SpinUp()
With Range("D4")
.Value = Range("D4").Value + 1
End With
End Sub
Reply With Quote
 

Tags
activex control, increment value, spinbutton



Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with incrementing Spinbutton value. 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 08:05 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft