[SOLVED - See last reply. #7]
I want to include a GIF image in a user form on a Mac. Any help is appreciated.
[SOLVED - See last reply. #7]
I want to include a GIF image in a user form on a Mac. Any help is appreciated.
Last edited by StuCram; 12-28-2014 at 11:18 PM.
On the Properties list for the userform, scroll down to Picture. Click on the ... on the right hand side. Then navigate to the picture that you want.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thanks, Trevor.
I've been trying that with my user form and with label & image items on the form. No luck.
- The file selection dialog does not allow me to select any files; all are greyed out.
I'm using Mac OS X 10.8 and Excel 11 for Mac.
Is there some other property that has to be enabled/changed as well?
Sad & somewhat frustrated,
- Stu
On a related issue, is there a way to paste in an image that has been copied (ex a partial screen capture)?
And is there an easy way to incorporate an image from another sheet into a new user form. (i.e. 'Picture 383' )
Just some things I'd like to be able to do but they don't seem to work.
-Stu
Hello Stu,
Unfortunately, VBA on the Mac is pretty limited compared to the PC version. So, I am not sure you do what you want. There are members here who are Mac users that can answer this question better than I can. Hopefully, someone will.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Star below the post.3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Like Leith, I cannot really give any advice on the Mac's capability.
With a PC, you can copy an image, select the box next to the Picture and Paste.
SOLVED (Sort of)
I discovered this information, courtesy of Ron deBruin's notes: http://www.rondebruin.nl/mac/mac024.htm
------------------------------
He wrote….
From the Manual :
In Excel 2011 it is not possible to load a 24 or 32 bit bmp picture manual in a image control on a Userform.
This is a bug in Excel 2011, convert your picture to a 256-color (8-bit) BMP and it will work.
Use the Picture property in the properties of the Image control to select the bmp picture you want.
Note : PictureSizeMode is not fill the image control on the Mac
You can use the picture property of a label instead, the picture will fill the label then.
You need to ensure that the label’s aspect ratio matches the picture’s aspect ratio.
------------------------------
So, I changed my images to .bmp & 8-bit format using the 'Graphic Converter' program for Mac.
Then, clicking the picture attribute of an image item on the user form allowed my to get & show that image.
Yea!
This may not give the high-resolution quality some may want but it worked well for my small b/w icon type images.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks