| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Difference between a Forms Control verus Active-X Control | Excel Discussion (Misc queries) | |||
| Format Control dialog box control tab | Excel Discussion (Misc queries) | |||
| Control tab does not appear in format control dialogue box | Excel Discussion (Misc queries) | |||
| spinner format control has no control tab | Excel Worksheet Functions | |||
| Control Tab from Combo box- format control missing!! | Excel Discussion (Misc queries) | |||
Linear Mode
