Userform SpinButton problem

O

Ozgur Pars

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
 
C

crazybass2

Ozgur,

Your code worked for me. What min/max value are you using and is there any
other code that effects the spinbutton, or the label?

Mike
 
O

Ozgur Pars

Mike,
thanks for your reply.

While I was repying I figured it out ...I only put code in the change of the
spinbuttons and did not load the numbers in the activate userform event. I
added it and it worked of course. But I am still puzzeled while only when at
minimum was not displayed... anyway thanks for your help.

Ozgur
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top