Show an msoImage in a Userform (Excel 2010)

[Keebellah]

Hi,
I was wondering if anyone has an idea (if it is possible) to show the image of a ribbon button in a Userform.
Let me explain. When you create a custom ribbon you place the msoimagefilename in the button and the corresponding image is shown in the button

The name '_50PercentComplete' (see ittached image, it's the 5th from the top left)

The idea is to show a dropdownlist in a userform and when one is selected, show the corresponding bitmap.

I hope I've been able to explain myself

[bulina2k]

i'm not sure if I perfectly understand the question but you could use some image object in your userform and loadimage code in the combobox change event:

Please Login or Register  to view this content.

[Keebellah]

Hi Bilina2k,
Maybe I was not able to explain myself correctly, if the image is present on any disk, then that would not be an issue, but thse images are not presnt anywhere except when you adress them in the Ribbon.
There are many ways to get the nmase of these corresponding images but not the image themselves
I attached page 2 of a 14 page pdf file wher you can see the name of the image and the image on the right.
For example: imageMso="FileManageMenu"
I can then then copy and paste this in the corresponding ribbon button and I will see that button, but when I customize the ribbon I would like to know what the image looks like if I only have the name

I hope this explains it a little Thanks for taking the time.

[bulina2k]

Maybe this could help? https://imagemso.codeplex.com/

[Keebellah]

Thank you, I had seen this one some time ago but had some issues when loading.
It loaded now, I've exported the ico files and will see if I can use this.
Will let you know.
Thanks again

[Keebellah]

@bulina2k: I exported the ones I wanted as bmp and that works fine now, Ijust made a selection and am implementing it my custom UI code so that the user can select the image shown in the Ribbon on-the-fly, something like Ribbon Commander but made easier and multi language
Thanks for the help and tips

[bulina2k]

I'm glad I could help!

[Andy Pope]

you can display msoImages using

Please Login or Register  to view this content.

[Keebellah]

Hi Andy,
I get the following error:
Run-time error '5':
Invalid procedure call or argument

Please Login or Register  to view this content.

However if I use Bulina2k's idea it will work but then I also need to have the image physically present somewhere to show it.

Please Login or Register  to view this content.

Your idea appeals more to me, but then I think I am missing either a reference in the VBA references that will interpret Application.CommandBars.GetImageMso correctly

Thanks for the tips, both of you

[Andy Pope]

tried the attached example.

[Keebellah]

Hi Andy, That's really strange. I compared the vba references in the attached file and her, they're identical and the attached file works and mine does not.

I even exported the frm module and improted it an then it won't work

Well, at least I've got worknign example. Thanks a million

[Keebellah]

BTW, how do I mark it solved in this forum?

[Andy Pope]

to understand why yours is not working we would need to see what you have.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[Keebellah]

Here's the file I wrote ...

[Andy Pope]

AccessNavigationOptions.jpg is not a valid msoImage name.

Change the contents of the textbox to Copy and double click the textbox

[Keebellah]

My dumb mistake for taking the name with th file extension.

Thanks dumb of me