View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Randal W. Hozeski Randal W. Hozeski is offline
external usenet poster
 
Posts: 33
Default SpinButton Rounding Up


Thanks for the follow up.
I guess that crash is a bad word to use.

When I use your example. It does allow my to use the textbox to
manually change the value, and it does not roundup. (what I requested)
but it does not allow my to use the up/down arrows of the SpinBox. It
just jumps between 1 to -1.

My goal here is to display to the hundredth and increment by .25 When I
created the Spinbutton and double clicked on it to enter the code I only
get a
Private Sub SpinButton1_Change()
which I then replaced with your code. (SpinButton1_SpinUp and SpinDown)
I doubled on the textbox and added the other.

It appears to be close. I just need to get the SpinButons to work.

-Randy-



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!