Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » VBA insert image in comment
|
|
|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
VBA insert image in comment
Resolved · Low Priority · Version 2010
Reply Thu 29 Sep 2011, 21:41Delegate Cristian said...
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
For upcoming training course dates see: Pricing & availability
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
Reply Sun 9 Oct 2011, 12:24Delegate Cristian said...
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
Sun 16 Oct 2011: Automatically marked as resolved.
|