Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
AJ
 
Posts: n/a
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
davesexcel
 
Posts: n/a
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
davesexcel
 
Posts: n/a
Default 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

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff
 
Posts: n/a
Default 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



  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
AJ
 
Posts: n/a
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
format an entire column to contain checkbox activex control blunoob New Users to Excel 1 December 19th 05 03:07 PM
date format in excel not in line with control panel regional setti GrahamR Excel Discussion (Misc queries) 3 August 2nd 05 07:48 PM
protecting format Esmerelda Excel Discussion (Misc queries) 1 February 25th 05 01:53 PM
Control Tab from Combo box- format control missing!! Mo Excel Discussion (Misc queries) 3 January 7th 05 02:09 PM
Copying list-box control Excel Discussion (Misc queries) 1 January 6th 05 02:39 AM


All times are GMT +1. The time now is 02:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"