how can i seperate listboxitems?

[alexschiefert]

ok i have got a listbox and there are several items (columns) in it.

can i seperate them by putting a line between the columns and how does it work if it is possible?

please help me

thx, alex

[alexschiefert]

does anybody know how to seperate the items in a listbox??

please help me!

thx, alex

[temped]

I'll help. I have done this recently my self. Try this:

Start a new work book
Start the VBA editor
add a user form named userform1
to userformform1 add a list box named ListBox1
add a commandbutton1 to your form.
copy the following code:

Private Sub CommandButton1_Click()

Rem extra CHR(9)'s added to increase the tab.
B = "Name" & Chr(9) & "Address" & Chr(9) & Chr(9) & "City"
ListBox1.AddItem B
Rem I hope this helps

End Sub

then double click on the CommandButton1 and paste this code covering all other code.
hit run
tell me if its what you wanted. I can make it much more complicated if you need it.
Good luck!