VBA for inserting an image into the comment box via user form

**antonymiller** · 07-13-2009, 05:55 PM

Admittedly, if this is even possible it is way beyond the scope of my understanding.

Question - is it possible to allow a user to insert an image into a comment box through a user form.

For example-

User enters Part # into form - then in a separate form field - uploads an image from his/her hard drive.

On submit the part number is populated into A1(or wherever) and comment box is also generated for A1 which contains said image.

Is it possible? If not - why?

Thanks.

**Mallycat** · 07-13-2009, 08:39 PM

No it is not possible. Because it is not possible to insert an image into a comment box - that's the way it was built

**Palmetto** · 07-13-2009, 08:52 PM

Yes, you may add an image to a cell comment. It may done manually by formatting the comment as follows:

Format Comment > Colors & Lines > Fill | Color > Fill Effects > Picture

See this link for helpful information. Develop your basic form and post back with your workbook and code for more help.

http://www.ozgrid.com/forum/showthread.php?t=84793

**antonymiller** · 07-13-2009, 09:55 PM

yeah I can do it manually - do it all the time. Just wondering if it was possible to do with vba.

**royUK** · 07-14-2009, 03:30 AM

You can add an image to a cell comment, manually or with VBA

Please Login or Register  to view this content.

To load an image into a userform see the Dtabase form example
here

http://www.excel-it.com/vba_examples.htm

**luvmyfam** · 04-19-2012, 11:39 AM

Is there a way to get this to locate the picture in a folder, then add it to the comment box, and then repeat down?

VBA for inserting an image into the comment box via user form

LinkBack

Thread Tools

Rate This Thread

Display

VBA for inserting an image into the comment box via user form

Re: VBA for inserting an image into the comment box via user form

Re: VBA for inserting an image into the comment box via user form

Re: VBA for inserting an image into the comment box via user form

Re: VBA for inserting an image into the comment box via user form

Re: VBA for inserting an image into the comment box via user form

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions