Results 1 to 1 of 1

Thread: [RESOLVED] Font list in VBA

Threaded View

  1. Jul 8th, 2006, 08:01 AM #1
    zaza
    zaza is offline

    Thread Starter
    Frenzied Member zaza's Avatar
    Join Date
    Apr 2001
    Location
    Borneo Rainforest Habits: Scratching
    Posts
    1,486

    Resolved [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.
    Last edited by zaza; Jul 8th, 2006 at 09:16 AM.
    I use VB 6, VB.Net 2003 and Office 2010



    Code:
    Excel Graphing | Excel Timer | Excel Tips and Tricks | Add controls in Office | Data tables in Excel | Gaussian random number distribution (VB6/VBA,VB.Net) | Coordinates, Vectors and 3D volumes
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width