MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

listbox problems in excel

  Asked By: Jodon    Date: Sep 19    Category: MS Office    Views: 1202

in excel, im having problems with the list box...
i have a form where i put a listbox...but when i
add items that are longer than the width of the
list box, the listbox doesn't show a horizontal



1 Answer Found

Answer #1    Answered By: Nicholas Wells     Answered On: Sep 19

Is this a 'listbox' or a 'combobox'? A 'listbox' from the Controls
Toolbox only shows one item with an up/dn arrow. The combobox shows a
down arrow and displays 'n' items  which is configurable in the
properties of the combobox. There are also listbox  and combobbox on
the Forms controls too (they act differently).

The default to size of the list  to show  in a combobbox is 8 (as set
in its properties). If you selected it from the Controls toobox then
right-click and select Properties then change ListRows item from 8 to

Didn't find what you were looking for? Find more on listbox problems in excel Or get search suggestion and latest updates.