Combo Box Control - CONTROL tab missing from FORMAT CONTROL dialogue

[Guest]

I have copied in Diana's question here because I have the exact same one as she and James, but no one has posted an answer online on this forum. If you can help, please post the answer here. Thanks

Hi All

I am adding a combo box to my spreadsheet but can't get
all of the Format Object dialog box to display.

After I add the combo box and right click on it to select
format control, 5 tabbed areas should appear. I only get
4. The Control tabbed area is not there where I need to
connect it to the input range. Size, Protection,
Properties, and Web Tabs are there. Has anyone else
heard of this? I tried this on 2000 and XP and on a
colleagues PC and none of them show the Control Tab.

Thanks again

- Al

 

[JE McGimpsey]

This has been answered by Diana herself. She was using the Combo Box
from the Controls toolbar (which doesn't have a Control tab in the
Format dialog), instead of the Combo Box from the Forms toolbar (which
does).

Do a Google search in the archives for her subject line:

http://groups.google.com/advanced_group_search?q=group:*excel*