Load Picture into Command Button on Userform - Not From File

[vthokienj]

I would like to load a picture onto a command button that has been imported into Excel. So far I can only see how this is done when loading the picture directly from a file. How can this be done?

For example, I want to do this, although this does not work:

myuserform.buttonOne.Picture = Sheets("sheet2").Shapes("thepicturename")

Thanks for any help.

 

[Sthrncali]

If my memory serves me, the proper workaround for this is to Export the picture to a temporary file, then load it to the userform via filepath.

Google exporting a picture as a chart object (jpg) to your hard drive.

Userforms don't want to grab pictures from worksheets for some reason.