multiple column Listbox - look like table

  • Thread starter Thread starter Ludo
  • Start date Start date
L

Ludo

Hi,

I have a form with 6 textboxes next to each other.
(Date,Description,Kilometers,Poststamps,Train & Divers)
Under those textboxes do i have a listbox (total width = width of the
6 textboxes) where the columncount is set to 6.

After exiting the sixth textbox, write i the data from the 6 textboxes
into a worksheet, and this data apears then in the listbox.

My question now is:
Is it possible to place a vertical line between every column in the
listbox to make it look as a table instead of a large "open field"?
Or is there a specific control that looks like a table?
I'm using Excel 2000.

Regards,
Ludo Soete
 
One idea is to add columns of "|" characters -- three keys to the right of
P -- between each data column in the listbox. It's not a solid vertical
line, but it helps.
 
Back
Top