Cristian has attended:
Excel Introduction course
VBA insert image in comment
In Excel training there was a mention of inserting an image into Comment via VBA. It would be great if somebody could start me with vba code (assume that image link already exists in a cell that needs to be passed to a Comment)
Many thanks
RE: VBA insert image in comment
Hi Christian, thanks for your query. Can you be a bit clearer about what you want to achieve? Are you talking about a picture in a floating comment box on the worksheet? Why do you need to do this?
Anthony
RE: VBA insert image in comment
Hi Anthony
Yes I meant the pic within a floating comment. Simple reason for it, to automate inclusion of images within a spreadsheet as I have the full image reference (so looking for a way to pass that reference to the comment box so that it is displayed). When I saw it during the training I had I thought that looks good and clients would like it.
RE: VBA insert image in comment
Hi Christian. This link includes code which should give you what you need:
http://www.ozgrid.com/forum/showthread.php?t=84793
Hope this helps,
Anthony
