Friday, 25 March 2011

Microsoft FaceID numbers for VBA programming

If you want to use Microsoft’s icons within your VBA (Visual Basic for Applications) code, you will probably have to refer to something called a ‘FaceId’. This FaceID requires a number which tells the office application which image to display. For example in the code you may see ‘.FaceId = 59’. microsoft-office-2007

This FaceID would give you the ‘smiley face’ icon when the code was executed.

So how do you know which number to use for which icon ?.


Thankfully, the answer lies in the following graphics.

1-500 501-1000
icons1-500 icons501-1000
1001-1500 1501-2000
icons1001-1500 icons1501-2000
2001-2500 2501-3000
icons2001-2500 icons2501-3000
3001-3500 3501-4000
icons3001-3500 icons3501-4000
4001-4500 5001-5500
icons4001-4500 icons5001-5500
5501-5685
icons5501-5685

2 comments: