Mac VBA & Excel, auto change image based on a cell
winstoncheets
- Posts
- 12
- Registration date
- Thursday June 7, 2018
- Last seen
- June 9, 2018
- Posts
- 12
- Registration date
- Thursday June 7, 2018
- Last seen
- June 9, 2018
Related:
- Mac vba & excel, auto change image based on a cell
- Excel auto change text - How-To - Excel
- How do you format a cell in excel to change color based on date? - How-To - Excel
- Excel auto change date - How-To - Excel
- Conditional formatting: change fontcolor based on another cell ✓ - Forum - Excel
- Excel vba change cell color based on another cell value ✓ - Forum - Programming
7 replies
- Posts
- 11176
- Registration date
- Monday June 3, 2013
- Status
Do this....
Change the path to the absolute path, and not the relative!
Use:
"C:\Users\"
If your username is not "danielcheetham", you need to got to "C:\Users\" and figure out who you are logged in as!
Understand, this is not even close to portable, and don't try it outside of the machine you built it on!
Change the path to the absolute path, and not the relative!
Use:
"C:\Users\"
If your username is not "danielcheetham", you need to got to "C:\Users\" and figure out who you are logged in as!
Understand, this is not even close to portable, and don't try it outside of the machine you built it on!
- Posts
- 11176
- Registration date
- Monday June 3, 2013
- Status
It works for me... see example:
In the above example I was not certain if the image would stretch to the RANGE, so I put a large range on it. It seems that the range can be a single cell, so deployment of:
will produce the same result as the posted example!
This is all I changed:
See example of how to deploy it!
It's kind of fun to do the impossible! -Walter Elias Disney
In the above example I was not certain if the image would stretch to the RANGE, so I put a large range on it. It seems that the range can be a single cell, so deployment of:
=picturelookup("eagleBadge",E2,1)
will produce the same result as the posted example!
This is all I changed:
("C:\Users\User\Desktop\" & Value & ".png", msoFalse, msoTrue, picLeft, picTop, -1, -1)
--
See example of how to deploy it!
It's kind of fun to do the impossible! -Walter Elias Disney
- Posts
- 11176
- Registration date
- Monday June 3, 2013
- Status
Here is another example of taking it just one more step, looking up the PNG value in a cell. The below example shows the same code changing the image based on the value in cell A1.
Please remember, this code only looks for PNG files, and if you are using a JPG, it is wrong. You could always just include the file format in the name, and drop the PNG from the static code, if you need the flexibility! See below!
Please remember, this code only looks for PNG files, and if you are using a JPG, it is wrong. You could always just include the file format in the name, and drop the PNG from the static code, if you need the flexibility! See below!
Hi ac3mark,
I created a eagleBadge.png in the pictures folder just so we are working off the same sheet.
I tried deploying it in the View Macros button on the Developer tab and got the error message as below
I tried entering it into the spreadsheet cell A1 and nothing happened,
I'm wandering if it is because Mac OS doesn't have the ActiveX controls..? And if so whether the VBA code could be adapted to use Form Controls instead?
...and thanks for getting involved in the troubleshooting
I created a eagleBadge.png in the pictures folder just so we are working off the same sheet.
I tried deploying it in the View Macros button on the Developer tab and got the error message as below
I tried entering it into the spreadsheet cell A1 and nothing happened,
I'm wandering if it is because Mac OS doesn't have the ActiveX controls..? And if so whether the VBA code could be adapted to use Form Controls instead?
...and thanks for getting involved in the troubleshooting
- Posts
- 11176
- Registration date
- Monday June 3, 2013
- Status
OK, in the VBA developer explorer, add in a new MODULE and place the code into that module, not on the 
If you placed the code onto the sheet itself, it needs to be cut from the sheet in the explorer, and added to the new module.
When you begin a new formula, and you start with "=pictur", does the line predictively finish with picturelookup? If not, then it is not in the correct location (module!). The worksheet should see it as a native formula, and try to predict what you want.
If you placed the code onto the sheet itself, it needs to be cut from the sheet in the explorer, and added to the new module.
When you begin a new formula, and you start with "=pictur", does the line predictively finish with picturelookup? If not, then it is not in the correct location (module!). The worksheet should see it as a native formula, and try to predict what you want.
- Posts
- 11176
- Registration date
- Monday June 3, 2013
- Status
No Problems. I like to learn how to teach, so I appreciate your patience.
That tells us that Shapes, are ActiveX, and you need some sort of middleware to interpret the ActiveX control,
Or;
the path is wrong to the image.
That tells us that Shapes, are ActiveX, and you need some sort of middleware to interpret the ActiveX control,
Or;
the path is wrong to the image.
ac3mark, thank you for your help. I think I may have to go back to the drawing board.
I'm trying to make excel find an image from the filename entered in a cell on sheet1 and paste it in a cell on sheet2, as below.
All automated when the filename is changed with images stored in a folder called pictures.
There's more than 1 filename in different cells on Sheet1 and the different images are to appear in different locations in Sheet2.
There has to be a way to get it working on Mac, perhaps just using form controls. Any advice appreciated as I have some learning to do.
Making Microsoft programs work smoothly on a Macintosh it could be kind of fun to do the impossible! :)
I'm trying to make excel find an image from the filename entered in a cell on sheet1 and paste it in a cell on sheet2, as below.
All automated when the filename is changed with images stored in a folder called pictures.
There's more than 1 filename in different cells on Sheet1 and the different images are to appear in different locations in Sheet2.
There has to be a way to get it working on Mac, perhaps just using form controls. Any advice appreciated as I have some learning to do.
Making Microsoft programs work smoothly on a Macintosh it could be kind of fun to do the impossible! :)