Control Tab from Combo box- format control missing!!

G

Guest

I cannot change the input range and cell link within the format control
option of a combo box.

Does anyone know why this control tab is missing?

Many thanks
 
J

Jim Rech

You should use a combo box from the Forms toolbar rather than the Control
Toolbox toolbar to see what you expect. Otherwise, right click the Control
Toolbox combo box, pick Properties, and enter the ListFillRange and
LinkedCell properties.

--
Jim Rech
Excel MVP
|I cannot change the input range and cell link within the format control
| option of a combo box.
|
| Does anyone know why this control tab is missing?
|
| Many thanks
 
B

Bob Phillips

Jim Rech said:
Otherwise, right click the Control
Toolbox combo box, pick Properties, and enter the ListFillRange and
LinkedCell properties.
Click to expand...

FYI. You have to be in design mode to do this
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format Control dialog box control tab 1
Why is the font tab missing from Format Control box? 1
Format Control Tab 1
Creating a Combo Box 4
Syntax for control source in combo box control 1
List Box in Control Tool Bar 7
Control Tab for Combo box 1
Control tab does not appear in format control dialogue box 1

Top