Me.ListBox1.RowSource = Worksheets("Sheet1").Range("A1:A10").Address

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"sam1" wrote in message
...

Hi,

Instead of coding every possible AddItem for a List box, how do i set
it on the user form to cover a range of data on a separate worksheet?


--
sam1
------------------------------------------------------------------------
sam1's Profile:
http://www.excelforum.com/member.php...o&userid=18280
View this thread: http://www.excelforum.com/showthread...hreadid=526857