Excel 2003 vba get picture as input

[Snoopy2003]

Hello,

I have a worksheet in which the user fills some personal details.
I wish to enable the user attach his photo and save it in my worksheet.
I was told that it should be saved as cell comment.
Is it possible to implement this in VBA ?

Thank you for your help

[unley]

Giday mate

Have you tried

Please Login or Register  to view this content.

?

Cheers

[Snoopy2003]

Hello,

Thank you for the useful link.

I succeeded uploading image to cell comment.

I have 3 questions:
1. How can I verify that the .Comment.Shape.Fill.UserPicture is not empty ?
2. How can I get the image back into a variable ?
3. Is it possible to paste the image into cell (not comment) ?

Thank you for your help

[unley]

Well, I'm not an expert in VBA but you should do some search in this site 'cause this site's the best to find answers.

Answer for question 1.
You can create buttons to open all comments to see if any comments have image and another button to close all comments

Create a button, insert new module in VBA windows and assign this macro to the button

Please Login or Register  to view this content.

Assign this macro to second button to close all comments

Please Login or Register  to view this content.

Answer to question 3.

check this site

Please Login or Register  to view this content.

Cheers mate

[Snoopy2003]

Hello,

Thank you very much for your help and support.
I will try to use it in my application.

Thank you for the useful advice