Hello all,

I just found the columnhead function and set it to TRUE.
But I didnt know how to add information in the headers so I tried to look it up on the internet.
Soon it became clear to me that you need to use the RowSource for it and that it can only be done by using a range from an excel worksheet and not from within the vba code itself.
This is all fine to me, but when I have data in a sheet called sheet1, and use the following code:
Generate_Add_Form.ListBox1.RowSource = "A2:G2"
it will show the names I have in the excelform as if it was the first record on my listbox, and the rest of my records have disappeared. So it is not in the columnheaders above it.
Does anyone know how to fix this?

Thanks in advance and cheers,

Devatu