View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ozgur Pars[_2_] Ozgur Pars[_2_] is offline
external usenet poster
 
Posts: 70
Default Userform SpinButton problem

Hello,
I am currently using spinbuttons on a userform and I am passing the current
values from an excel sheet onto them.

Something like:
Private Sub UserForm_Activate()
SpinButton1.Value = Sheets(1).Range("B1")
end sub

The problem is that if the current value is the minumum value of the
spinbutton the label.caption does not display this number. In all the other
cases the correct number is displayed(including the max number of the
spinbutton)
Why is this happening and how can I display the minumum numbers also?

Thanks,
Özgür