ListBox Text Spacing (Column Spacing)?

[razzandy]

When ever I use a listbox or combo box linked to a table on a worksheet, lets say with 3 columns I can never get the spacing even! I change the column count to 3 and the Column Spacing to what ever suits but I notice the 1st two columns are positioned quite close, but the rest are bigger. I’ve even tried altering the listbox/comboBox sixes. Does anybody have an easy solution for this??

Thanks in advance

Cheers

Ryan UK

 

[Steve Jukes]

razzandy

What I do is look at the listbox properties and find out its width and then set the columnwidths section in the properties to whatever figure is the width divided by the number of columns.

EG
Columncount 3
width 75
therefore columnwidths 25;25;25

Hope this helps

Steve

 

[razzandy]

Cheers Steve :wink:

I did'nt know you had to enter the column width value for each column! ;(

Thanks

Ryan UK :wink: