spinner format control has no control tab

[AJ]

I need to change the incremental figures for a calculation but cannot get the
spinner to work. I insert a spinner, right click, format control - here I'm
stuck, the instructions say use the control tab to format the increments buit
I do not have one.

Can I get an example or how to fis this please.

Regards,

Adrian

 

[davesexcel]

where did you get the spinner?

 

[davesexcel]

get the spinner from the forms tool bar

 

[Biff]

Hi!

You probably have a spinner from the control toolbox. You probably want the
spinner from the Forms toolbar. Right click any toolbar and select Forms.
There you'll find the spinner with the format control>control tab.

Biff

 

[AJ]

Thanks guys,

I managed to find it under view>forms> "not by using the control toolbar" as
I was.

Why does MS help not indicate this little problem in the help section? It
would save some confusion to many people I'm sure.

I now have an excellent model and our mortgage options are available at a
glance and not in some huge table.

Thanks all