I have Column A to BH in my excel sheet. I want to display column A, B ,C,E, G and BH in a userform listbox. I've managed to use VBA to add selected column data into the listbox. My problem is I have no idea how to create a list header on top of the list box. I try using the additem but it doesn't work. My listbox has horizontal scroll bar as the list is too long so I can't use label to create the list header name.
Bookmarks