Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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" wrote in message ... |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 |
#3
|
|||
|
|||
"Jim Rech" wrote in message ... 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 |
#4
|
|||
|
|||
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" wrote in message ... |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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change font in a forms control combo box | Excel Discussion (Misc queries) | |||
Copying list-box control | Excel Discussion (Misc queries) | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) | |||
combo box formatting | Excel Discussion (Misc queries) |