Control Tab from Combo box- format control missing!!

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

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
"Mo" <[email protected]> wrote in message
news:[email protected]...
|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

"Jim Rech" <[email protected]> wrote in message
news:%23dEpb6%[email protected]...
> Otherwise, right click the Control
> Toolbox combo box, pick Properties, and enter the ListFillRange and
> LinkedCell properties.

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

Thank you very much. That helps alot.

"Jim Rech" wrote:

> 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
> "Mo" <[email protected]> wrote in message
> news:[email protected]...
> |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
>
>
>