Excel spin box - no Control tab in Format Control dialong box

[tocoau]

Hi

When attempting to use a Spin Box in Excel 2003, I set it up, right-click on
it and then click on Format Control. However, there is no Control tab (only
the Size, Protection, Properties & Web tabs)

How do I get the Control tab to appear?

Regards
TC

 

[Gord Dibben]

Use the spinner from the Forms Toolbar, not from the Control Toolbox


Gord Dibben MS Excel MVP

 

[tocoau]

Hi, Gord

Pardon my ignorance (first timer)...but where is the Forms Toolbar located?

Regards
TC

 

[Gord Dibben]

With Excel worksheet window visible...................

View>Toolbars>Forms


Gord

 

[tocoau]

Thanks, Gord!

TC

With Excel worksheet window visible...................

View>Toolbars>Forms


Gord

 

[Gord Dibben]

Glad to help.

Good luck with the project.


Gord

 

[tocoau]

Hi, Gord

Sorry to be a pain (again/still)

I want to use a Spin Button to refer to Fitout Cost for a project, with
increments up/down to see what effect it has on borrowings, etc

But I can't work out how to get the initial projected cost (say $500,500k)
into the "Current Value" and minimum & maximum values of say $475,475k and
$550,550k into the respective cells - as soon as I do, it comes up with the
message "Scroll value must be between o and 30,000"

I'm obviously doing something wrong, something fairly basic, but can't work
out what.

Regards
Tony

 

[Gord Dibben]

OK.

Now we know some details.

The Forms spinner is limited to 0-30000

Back to the spinner from Control Toolbox from View>Toolbars.

Create a spinner on the sheet then right-click and "Properties"

Type in a Min and Max and SmallChange(defaults to 1) and designate a linked
cell to receive the number.

Hit the "Design Mode" Icon on the Control Toolbox toolbar to exit design
mode.

Your formulas on the sheet will refer to the linked cell for calculations.


Gord