User Form ListBox Column Widths - How to set widths for unknown number of columns

I am using UserForm_Initialize to populate a listbox with an array. I don't know how many columns the array will have. I want to:

1. set the first column to 0 points (to hide the primary key column)
2. and the rest (however many columns there are) to either default/autosize/49.95 pts(I don't care too much about the remaining column widths )

How do I do this?

This is where I am up to so far:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

If you want autosize widths then

Please Login or Register  to view this content.

Brilliant work. Just what I wanted.

you may also just use

Please Login or Register  to view this content.

Originally Posted by JosephP

you may also just use

Please Login or Register  to view this content.

It was that simple! Thanks!