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

James,

Take a look he

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


--
Hope that helps.

Vergel Adriano


"Zone" wrote:

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

Looks good! Thanks, Vergel.

"Vergel Adriano" wrote in message
...
James,

Take a look he

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


--
Hope that helps.

Vergel Adriano


"Zone" wrote:

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