ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel 2003: Control tab in "Format Control" doesn't show up. (https://www.excelbanter.com/excel-programming/381479-re-excel-2003-control-tab-format-control-doesnt-show-up.html)

Tom Ogilvy

Excel 2003: Control tab in "Format Control" doesn't show up.
 
Control Format Toolbar

should have been
Control Toolbox Toolbar

--
Regards,
Tom Ogilvy

"Tom Ogilvy" wrote in message
...
Make sure you are using a control from the Forms toolbar rather than the
Control Format Toolbar.

You probably are since you say the other tabs are there.

The other thought is you are using a textbox from the Drawing toolbar
rather
than from the forms control. This doesn't have a control tab. You would
click in it, go to the formula bar and enter =A1<return

to link it to a cell.

In any event, everything worked as expected with Forms controls in xl2003
SP2.

--
Regards,
Tom Ogilvy




"GoNavySubGuy" wrote:

I have used Excel 2003 SP1 before and when I draw a control, right click
on
it, select "Format Control" from the menu - there is a "Control" tab that
shows up, and allows me to tie the control to a cell address. I am now
using
Excel 2003 SP2 and when I do the same, I find no "Control" tab. The
other
tabs are there, but not the tab that lets me tie the control to a cell.
How
do I configure the control without that tab?!





All times are GMT +1. The time now is 01:36 AM.

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