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