Take a look at the section entitled
How to use the RowSource property to populate a ListBox control with cells
on a worksheet

in

http://support.microsoft.com/default...b;en-us;829070
How to use Visual Basic for Applications examples to control UserForms in
Microsoft Excel

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Sean Stuber" wrote in message
...
the user form is looking good.
however, i am unclear about how to add items to it. I want to use a
list of items stored within cells of a worksheet.

thanks,
sean



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!