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

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

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

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


Gord Dibben MS Excel MVP

On Sat, 9 Aug 2008 13:32:11 -0700, tocoau
wrote:

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

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

Hi, Gord

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

Regards
TC

"Gord Dibben" wrote:

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


Gord Dibben MS Excel MVP

On Sat, 9 Aug 2008 13:32:11 -0700, tocoau
wrote:

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

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

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

ViewToolbarsForms


Gord

On Sat, 9 Aug 2008 13:55:00 -0700, tocoau
wrote:

Hi, Gord

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

Regards
TC

"Gord Dibben" wrote:

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


Gord Dibben MS Excel MVP

On Sat, 9 Aug 2008 13:32:11 -0700, tocoau
wrote:

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

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

Thanks, Gord!

TC

"Gord Dibben" wrote:

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

ViewToolbarsForms


Gord

On Sat, 9 Aug 2008 13:55:00 -0700, tocoau
wrote:

Hi, Gord

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

Regards
TC

"Gord Dibben" wrote:

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


Gord Dibben MS Excel MVP

On Sat, 9 Aug 2008 13:32:11 -0700, tocoau
wrote:

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

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

Glad to help.

Good luck with the project.


Gord

On Sat, 9 Aug 2008 14:22:01 -0700, tocoau
wrote:

Thanks, Gord!

TC

"Gord Dibben" wrote:

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

ViewToolbarsForms


Gord

On Sat, 9 Aug 2008 13:55:00 -0700, tocoau
wrote:

Hi, Gord

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

Regards
TC

"Gord Dibben" wrote:

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


Gord Dibben MS Excel MVP

On Sat, 9 Aug 2008 13:32:11 -0700, tocoau
wrote:

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

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

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" wrote:

Glad to help.

Good luck with the project.


Gord

On Sat, 9 Aug 2008 14:22:01 -0700, tocoau
wrote:

Thanks, Gord!

TC

"Gord Dibben" wrote:

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

ViewToolbarsForms


Gord

On Sat, 9 Aug 2008 13:55:00 -0700, tocoau
wrote:

Hi, Gord

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

Regards
TC

"Gord Dibben" wrote:

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


Gord Dibben MS Excel MVP

On Sat, 9 Aug 2008 13:32:11 -0700, tocoau
wrote:

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

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

OK.

Now we know some details.

The Forms spinner is limited to 0-30000

Back to the spinner from Control Toolbox from ViewToolbars.

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


On Sat, 9 Aug 2008 16:37:01 -0700, tocoau
wrote:

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" wrote:

Glad to help.

Good luck with the project.


Gord

On Sat, 9 Aug 2008 14:22:01 -0700, tocoau
wrote:

Thanks, Gord!

TC

"Gord Dibben" wrote:

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

ViewToolbarsForms


Gord

On Sat, 9 Aug 2008 13:55:00 -0700, tocoau
wrote:

Hi, Gord

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

Regards
TC

"Gord Dibben" wrote:

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


Gord Dibben MS Excel MVP

On Sat, 9 Aug 2008 13:32:11 -0700, tocoau
wrote:

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