Greetings to all on this cool Saturday night from the Holy City of Jerusalem!

I think I might be able to stump you geniuses with this one:

I need to ask the user to choose an available char style in the doc. Opening a dialog/list box with a list of the styles, I think I can handle on my own. But is there a way that within this dialog box, the styles should be shown formatted per their actual formatting (font type, bold, etc). I have already been told it cannot be done, but as we know Grandma always said "Never say never".

Thank you and have a good day!

Susan Flamingo

Maybe this would require custom ribbon coding.

There is very limited support to set font attributes for User Form controls, but not sufficient to replicate character styles. If your character styles have been named according to their purpose, why would the user need to know what the results will look like?

There is nothing in Ribbon XML to specify font attributes for ribbon controls.

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