ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   spinner format control has no control tab (https://www.excelbanter.com/excel-worksheet-functions/75303-spinner-format-control-has-no-control-tab.html)

AJ

spinner format control has no control tab
 
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

spinner format control has no control tab
 

where did you get the spinner?


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=519028


davesexcel

spinner format control has no control tab
 

get the spinner from the forms tool bar


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=519028


Biff

spinner format control has no control tab
 
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 controlcontrol tab.

Biff

"AJ" wrote in message
...
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




AJ

spinner format control has no control tab
 
Thanks guys,

I managed to find it under viewforms "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


All times are GMT +1. The time now is 01:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com