List box

  • Thread starter Thread starter Todd
  • Start date Start date
T

Todd

I am trying to use the list box function from the control
toolbar. I am not sure how to get the listings I want in
the list box. Is there certain VB coding that is needed?
Any help will be appreciated. Thanks.

Todd
 
No VBA code needed. In Design mode, click on your list box and select
Properties from the Control toolbox (or right-click your list box and select
Properties), then scroll down to the ListFillRange Property and indicate the
cell range address that has the items you want to appear in the box (i.e.,
A1:A10). Then exit out of design mode and test your list box.

MRO
 
-----Original Message-----
No VBA code needed. In Design mode, click on your list box and select
Properties from the Control toolbox (or right-click your list box and select
Properties), then scroll down to the ListFillRange Property and indicate the
cell range address that has the items you want to appear in the box (i.e.,
A1:A10). Then exit out of design mode and test your list box.

MRO





.
Another way is to use Data, Validation, List. Just
Click to expand...
create your list in another area and give it a name. Then
highlight the range where you want the list to appear,
choose Data => Validation => List and in the Source box,
put "= RAnge Name" where Range Name is the name of the
range containing the list. It is very easy, Good Luck
 
Back
Top