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

--
Message posted from http://www.ExcelForum.com