| 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 |
| 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) | |||
Hybrid Mode
