Using a list box in a vba userform, I don't believe you can have multiple items, each with their own font formatting.
To get similar functionality in a userform, I would put a secondary text label with dummy text and have a macro change its formatting depending on the list item selected in actual list box.
If I wanted a visual clue of the styles on the ribbon, just make use of the existing visual displays which already do this. Make sure the character styles were included in the Styles Pane and/or Quick Styles list and check the 'Show Preview' setting is enabled.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
|