Can I Format Column Headings in Listbox on Excel User Form?
Posted on 2011-03-10
I have a lsit box on a user form which has the row source set to a range in a worksheet. No problem getting the column headings to appera, but I want to know if it is possible to format the column headings as they are small and don't stand out enough. I have used labels above the list box, but if there is a lot of data in the columns then the box may scroll to the right which will obviously take the columns out of alingment with the labels. I suspect this may not be possible, but can I make the headings bold or change the colour?