Hi, I need to find out if theres a way I can align text in a list box.

Heres How im filling the text box....


Code:
--------------------
set Daily = worksheets("Daily")

with userform1.listbox1
.additem daily.cells(x, 1) & " " & daily.cells (1, x) & " " & Daily.cells(x, x)
end with
--------------------



There are basicaly 3 colums.
I need the left aligned to the left of the listbox, center to the
center, and right to the right. I'm not sure on this one so I thought
I'd throw it out there and see if its possable.

Thanks in Advance!!
Chris


--
justchris
------------------------------------------------------------------------
justchris's Profile: http://www.excelforum.com/member.php...fo&userid=8894
View this thread: http://www.excelforum.com/showthread...hreadid=400729