ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Control tab does not appear in format control dialogue box (https://www.excelbanter.com/excel-discussion-misc-queries/144833-control-tab-does-not-appear-format-control-dialogue-box.html)

Phunky E

Control tab does not appear in format control dialogue box
 
When I add a control (specifically a scroll bar), I am unable to enter the
control properties (such as max value, min value, linked cell) because the
"control" tab on the Format Control dialogue box does not appear. I can,
however, copy a working scroll bar from another file and edit that one (i.e.
the control tab is present for existing scroll bars). Anyone have any idea
why this is happening?

Jim Rech

Control tab does not appear in format control dialogue box
 
I'd guess that you're adding a scroll bar control from the Control Toolbox
toolbar whereas the copied ones come from the Forms toolbar. You can set
the properties of the former via right-click, Properties.

--
Jim
"Phunky E" <Phunky wrote in message
...
| When I add a control (specifically a scroll bar), I am unable to enter the
| control properties (such as max value, min value, linked cell) because the
| "control" tab on the Format Control dialogue box does not appear. I can,
| however, copy a working scroll bar from another file and edit that one
(i.e.
| the control tab is present for existing scroll bars). Anyone have any idea
| why this is happening?




All times are GMT +1. The time now is 04:28 AM.

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