Display all installed fonts (Excel) using VBA in Microsoft Excel

The macro below will display a list of all installed fonts. Note! If you have many fonts installed,
the macro may stop responding because of lack of available memory. If this happens you can try the
sample for Word later in this document.

Users are saying about us...

  1. This will not compile due to replacement of & by HTML escaped versions.

    Cut and paste the code into VBA.
    Use search and replace for the following three items
    <
    & &

    Brace yourself for a font avalanch.
    Click execute. 🙂

  2. Double Drat!
    OK there are things in the code that start with an ampersand and end in a semi colon that need to be replaced with other things.

    You have 30 seconds.

    GO!

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Youtube