Combo Box - extending the number of rows

J

Joe

Hi there,
I can't seem to right-click on a combo box.
I have the Control Toolbox - Design Mode button selected
and I've checked to see if the workbook/worksheet is
protected ( which they aren't )...
I right-click on the combo box object but I don't get a
menu to select the option "Format Control".
I thought this is where you can extend the combo box range
( rows ) of rows.
Any feedback would be greatly appreciated.

Thanks,
Joe
 
I

icestationzbra

joe,

i am a tyro at excel myself. i cannot figure out why are you not abl
to right-click on the combobox once you have the design mode on. at th
cost of sounding silly, is it by any chance a form combobo
(anywhichway you should still be able to right-click)?

the second part - in a control-combobox, the number of lines is not se
in Format Control. it is set in Properties - ListRows.

the only case where i was not able to see the Properties pallette i
when i had password-protected the code. you can check that b
right-clicking on any tab and selecting View Code. it might ask you fo
a password. provide the password there and then come back to th
combobox and try right-clicking again.

<end of file> for my expertise.

mac
 
D

Debra Dalgleish

While in Design mode, select the combo box
On the Control toolbox, click the Properties button
Change the setting for ListFillRange, to include all the rows.
Exit Design mode
 
Top