Image inserting issue in VBA (Mac)

Question

Hi,

I am trying to create a customized userform in VBA using M1 Macbook Air and Parallels. Unfortunately when I would like to insert an image there is no pop-up library I could choose the picture. The image inserting works well in Excel but it doesn't in VBA. It looks a quite native function so I am a bit confused what is wrong. I would appreciate any advice how I can make VBA work as expected. Thanks in advance! Gergo

Answer 1

The 32-bit versions of Office for Mac do not share the same code base with Office for Windows.

The 32-bit versions of Office for Windows do not share the same code base with 64-bit Office for Windows.

64-bit Office for Mac and Windows share the same code base.

The 64-bit version of Office for Mac is "sandboxed" which can wreak havoc when trying to perform file operations. Sandboxing is optional for Office for Windows.

Answer 2

Hi

Is the picture to be placed on the userform or on a worksheet?

Hi,

I would like to place the picture on the userform. Inserting picture on the worksheet works fine. Should I reinstall Excel or Windows?

Answer 3

Hi

Is the picture to be placed on the userform or on a worksheet?

Answer 4

Hi

Please explain a bit more about the source of the image. Is it a file on your Mac? A file from a different storage device? An on-line image?

Thank you for the reply!

It is a local file stored on the Mac. The problem is that I can't choose any files because the load picture dialog box doesn't appear in case of image control. If you need any further details just let me know. I'm sorry for the poor description but I am not sure where to look for the root cause. Thank you again for the questions!

Answer 5

Hi

Please explain a bit more about the source of the image. Is it a file on your Mac? A file from a different storage device? An on-line image?