Font list like font menu in excel

[milt2010]

Hello.

I have a list name with fonts in a cell. It is possible, in the list, to see the fonts like in the font menu of every program in windows with its caracteristics?

Take a look to the attachment please.

Thanks

[protonLeah]

Please Login or Register  to view this content.

[pike]

or another gem from John Walkenbach

Please Login or Register  to view this content.

[milt2010]

Thank you for your help!

It is possible the list inside of my menu to look exactly like the font menu of excel? I mean, you can see the font as it looks like before you choose it in excel font menu. Instead, with the code

Please Login or Register  to view this content.

it can be possible only after you choose the font.

It is possible to change this?

[romperstomper]

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!

Read this to understand why we ask you to do this.

Cross-posted here.

[milt2010]

You are right. I'm sorry. I forget to post the link of cross-posted.

[milt2010]

Thank you for your help!

It is possible the list inside of my menu to look exactly like the font menu of excel?(...)

I'll try to be a little more clear, with the help of two pictures.
My menu, created with a name list in excel, is as in picture 1;
what I would have, is to see the font in the list as seen in picture 2.
I don't care off course about the TT (true type) symbol, but the true appearance of fonts is what I need.

[romperstomper]

That is not possible, I'm afraid. Perhaps if you explain your ultimate purpose, we can suggest an alternative method.

[milt2010]

That is not possible, I'm afraid. Perhaps if you explain your ultimate purpose, we can suggest an alternative method.

I will try to explain a bit more.
I will use this worksheet with others and my purpose is to facilitate the choise of a font (seen how it look like), when someone choose from the name list menu that I have put inside the worksheet.

[romperstomper]

What is wrong with Excel's own font list?

[milt2010]

What is wrong with Excel's own font list?

Nothing at all, but because I use my worksheet to export a txt file (after I put inside some data) it is not useful for my purpose.

[romperstomper]

I'm afraid that makes no sense to me. Text files contain no formatting information, so what is the relevance of the font dialog?

[milt2010]

I'm afraid that makes no sense to me. Text files contain no formatting information, so what is the relevance of the font dialog?

It is very difficult for me to explain the entire operation of the worksheet, and I'm afraid that confuses you more.
As I said, the worksheet creates a txt. Txt exported is then sent to a forum and format is given by the bbcode.
So if you define the fonts, will show them where the txt will be sent to the forum. In the Attachment you can see the string in the txt and, below, how it appears.

Eg.

Please Login or Register  to view this content.

So the point is, that is useful to see, in the worksheet (before to post) how the font looks like.

I hope this help!