Hi,
I have a listbox on a Userform and it fills correctly, but I can't seem to put headings on the listbox using a mulitidimensional array 7 columns. Code is as follows:
ListBox1.List = vMultiDimArray
Can I write code to manually assign each column a heading and is it possible to right or left justify each column in the list box differently ie can I have column 1 left justified and column 7 right justified?
Your assistance would be great!
Thank you.
Michael.
I have a listbox on a Userform and it fills correctly, but I can't seem to put headings on the listbox using a mulitidimensional array 7 columns. Code is as follows:
ListBox1.List = vMultiDimArray
Can I write code to manually assign each column a heading and is it possible to right or left justify each column in the list box differently ie can I have column 1 left justified and column 7 right justified?
Your assistance would be great!
Thank you.
Michael.