Excel VBA macro to display built-in FaceId icons and numbers in a worksheet.

The CommandBarButton.FaceId Property is used to set the look (icon) of buttons used on a command bar (like the ribbon or a popup menu).

The repo includes a PDF "faceid-number-1-to-20000.pdf" made with this macro showing the FaceId icons from number 1 to 20000.

Clone or download the repository. You can also download the Excel file faceid.xlsm directly.

The macro "faceids_to_wks" is located inside the module "faceid" in the Excel file "faceid.xlsm".

Call the Sub faceids_to_wks with the following parameters:

Example call (included in the module "faceid"):

'example for calling the main sub and display FaceId 1 to 1000 in the wks
'the output of this is already generated and visible in the worksheet "faceid"
Sub call_faceid()
    Call faceids_to_wks(ThisWorkbook.Worksheets("faceid"), "B2", 1, 1000, 25)
End Sub

Remark: The module gets automatically exported when saving the Excel file. To stop this behavior change the constant in the module "autoopen" to "False":

Private Const is_in_development As Boolean = False

If you find a bug, please create a new issue. Pull requests are also welcome.

• Daniel Hubmann (Author)

Copyright (c) 2016 Daniel Hubmann. Licensed under MIT.