spin button

[bam12]

I am new to spin buttons

The maxinum value will be around 80000.
could anyone tell me how to do this and also how to assign it to a cell

 

[Norie]

What type of spin button Forms or Control Toolbox?

Forms:

Right click the control, select Format Control and you can set the max/linked cell etc on the Control tab.

Control Toolbox

Right click the control, select Properties and again you can set the properties.

 

[bam12]

control

control one

 

[bam12]

form

form spin buton only goes to 30000 in excel 97

 

[Norie]

Same with 2000, so why not use one from the Control Toolbox?

 

[bam12]

i am

i am using that one, do i ahve to write code for it?

 

[Norie]

Sorry I don't understand what you mean.

To set the Max/Min and Linked Cell right click it and select Properties, like I said in my 1st post.

 

[bam12]

i did that

Norie
I did that i linked cell and set max and min
but when i click on it it keeps wanting to move the spin button

Sorry if i am making it difficult

 

[Norie]

Sounds like you are still in design mode.

Just click the Set Square (little green triangle) on the toolbar.

 

[bam12]

found problem

Norie

Sorry i found the problem it was in design mode

Thanks for the help