Combo Box - extending the number of rows

[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

 

[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

 

[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