Hi
The way I suggested in an earlier post.

Is the button you are clicking on the form with the listbox? If it is,
then it is very strange to populate the listbox using a button on the
same form - why not do the populating in the initialize sub as I
suggested? Now use your button to run the lable changing code.

regards
Paul

#DIV/0 wrote:

Hang on. Figured it. I left
ListBox1.ColumnCount = 3
ListBox1.ColumnWidths = ";0;0"
in UserForm_Initialize and put all the rest in the button_Click

Now I want the ListBox1_Click to put the values of the hidden columns into
label captions. How do I do that ? ListIndex ? Offset ?

--
David M