How do I polpulate a list box?

  • Thread starter Thread starter Christiane
  • Start date Start date
C

Christiane

How do I populate a list box in Excel.

I copyied this code from the help, but I am not sure what I should pu
in the brackets and what shape is for.



Private Sub CAtegory_Click()

Worksheets(1).Shapes(CAtegory).ControlFormat.List = _
Array("cogs", "widgets", "sprockets", "gizmos")

End Sub

My sheet is named OrderForm.

THanks.

ANd how do I get the scroll bar
 
Are you trying to fill it dynamically - based on a condition. If not, just
select the listbox in design mode and set the listfillrange property to the
cells that you want to use to populate the listbox.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error populating a list box 1
List Box Change Event 8
Display cell contents in a text box (shape) and linking 2
Checkboxes and Arrays 3
How do I lookup several values and concatenate the results? 1
Shapes into List Box 4
Use VLOOKUP to populate text box on form 8
VBA code causes Find and Replace dialog box to lose focus 2

Back
Top