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

  • Thread starter Thread starter tocoau
  • Start date Start date
T

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
 
Use the spinner from the Forms Toolbar, not from the Control Toolbox


Gord Dibben MS Excel MVP
 
Hi, Gord

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

Regards
TC
 
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
 
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
 
Back
Top