List of Fonts

[Zone]

I want to show a list of available font names, have the user select a name
from the list, and put the name of the selected font into a cell. I do not
want font size, color, etc. shown, just the names of the fonts. It would be
ideal to show the font selection box from the format toolbar, but I don't
know if that's available for use this way. Alternately, I could show a
userform with a listbox or combobox and the font names in there, but I don't
know how to populate that with the available font names. Ideas? TIA, James

 

[Guest]

James,

Take a look here:

http://j-walk.com/ss/excel/tips/tip79.htm

 

[Zone]

Looks good! Thanks, Vergel.

James,

Take a look here:

http://j-walk.com/ss/excel/tips/tip79.htm