Excel FaceID - individual icons

[Formula11]

Hi, is there anywhere these individual icons are available.

VBA Ribbon - Face Ids 2003
For the latest Office version though.

I was planning on inserting some of the images in a VBA userform.

 

[Micron]

IIRC those icons are part of a "sheet" (dll file) and can only be used by referencing the face id. If you Google "excel button icons" or similar, you'll find there are tons of links and millions of icons that you can use as the picture property for a userform button.

 

[Formula11]

Thanks, I have tried this but can't find anywhere.
I think it may be because all the icons may be inside something like a dll file.

 

[Micron]

That has not been my experience. All of the icons I have were individually downloaded or as collections. Maybe this is one you could use

Excel Icons, Logos, Symbols – Free Download PNG, SVG

Free Excel icons, logos, symbols in 50+ UI design styles. Download Static and animated Excel vector icons and logos for free in PNG, SVG, GIF

icons8.com

 

[Formula11]

OK thanks, but the icons are as per link in OP, called FaceID.

 

[Micron]

Sorry, you're not making sense to me. Here is the individual icon that I have for #1 face id at that link. Forum probably won't do it justice, but...

 

[Formula11]

Hi, yes you're right, however I still could not find even this icon in your link.
Point taken though.
But is there a site with just the Face IDs exactly as they appear in Excel.

 

[Micron]

I didn't say I got it from there. I have no definitive answer to your last question except to say that the posted icon is just one of over 2,700 individual icons that I've collected over the years. Some are in collections. The posted one came from Access Toolbar Icons collection. A lot of icons are applicable to more than one Office app so if you find Access or Excel icon downloads they might contain usable images. You'll just have to search, I guess.

 

[Formula11]

Ok no worries.

 

[Dan_W]

As far as I am aware, there isn't a handy, up-to-date 'catalogue' of FaceIDs - though I have thought about preparing one. FaceIDs are a bit random and there doesn't appear to be much of a rhyme or reason as to how, where or why they are added, though I would be curious to learn more about them. It's easy enough for you to create your own 'catalogue' of FaceIDs if you're really interested, though - essentially, it's just a matter of looping through a range of numbers, and then copying and pasting each FaceID to a worksheet. I can dig out some code that accomplishes this if you like. Alternatively, there are addins to Excel that will generate a tab in the ribbon and display a select range of them. When I tried to make my own catalogue, I recall that the last FaceId I could find was around the #18000 range, but that's not to say that there are 18000 FaceIDs. There can be hundreds/thousands of blank ones in between each of them!

But may I ask what you wanted them for in your Userform? I'm curious because I can probably save you some time or come up with a better solution. For example, you may be better off using the newer imageMso - these are the images you see used in the Ribbons and throughout the Office product suite, whereas FaceIDs are those images that you see in the VBA Editor.