View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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?!