Link to home
Start Free TrialLog in
Avatar of Karl_mark
Karl_mark

asked on

Can I Format Column Headings in Listbox on Excel User Form?

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?
SOLUTION
Avatar of Arno Koster
Arno Koster
Flag of Netherlands image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of Rory Archibald
Rory Archibald
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Karl_mark
Karl_mark

ASKER

Thanks guys. I don't have time to change it to ListView right now, but may take a look once I get this finished.
This question has been classified as abandoned and is being closed as part of the Cleanup Program. See my comment at the end of the question for more details.