View Single Post
 
Old 02-18-2024, 05:38 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,176
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

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
Reply With Quote