[RESOLVED] Font list in VBA

Afternoon,

I'm after putting a font list on a VBA userform without resorting to one of the dialogs.

There is no System namespace as in VB.Net, nor a Screen object as in VB6. Any other ideas?


I should also add that I'm using Excel, not Word, so I can't use the FontNames approach without referencing the Word object library. This is my current means of accomplishing it, but I was wondering if there was another way without having to reference Word.


Cheers

zaza


Edit: Never mind. I used the API, which works well.