multiple column Listbox - look like table

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
 
T

Tim Zych

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top