View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tim Zych Tim Zych is offline
external usenet poster
 
Posts: 389
Default multiple column Listbox - look like table

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.

--
Regards,
Tim Zych
http://www.higherdata.com
Workbook Compare - Excel data comparison utility


"Ludo" wrote in message
...
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