Hello,


I need to be able to have the user select a font from the installed fonts,
and return the font name to af string-variable.

I've tried some of the builtin dialogs:

.Dialogs(xlDialogActiveCellFont)
.Dialogs(xlDialogFont)
.Dialogs(xlDialogFontProperties)
.Dialogs(xlDialogFormatFont)

But, in all these dialogs, the user can change/select all sorts of font
properties, besides the name, ie. the color, bold, underlined, size, etc...
Besides, these dialogs require quite some programming to save the font name
to a string-variable!

I need a dialog where only the font names can be choosen from?
Does such a dialog exists?

Perhaps it needs to be done with a UserForm?
But then, how to populate a listboks with the names of the installed fonts?


Help apreciated,

Thanks in advance...