Giving particular unique names to a image when uploaded in vba

[jakeembx]

Hi everyone

Does anyone know some code that will give a particular unique name to a image, when it is uploaded via a userform by a user???

thank you!

[Leith Ross]

Hello jakeembx,

Can you give an example of what you mean?

[jakeembx]

Background: the form allows a user to type a students personal data and upload a profile image

Example: when a user has filled in the personal data part of the form, they will click on the add a profile image button that will display a file picker for them to upload a pupils profile image.

I currently know the code to do this and save the image to a particular cell range within a worksheet but don't no how to name the image when it is saved to the document and worksheet??

[Leith Ross]

Hello jakeembx,

When pictures are added to a worksheet, they are added to the Pictures collection for that worksheet. Since each picture you add will always be last one in the collection, you can reference it this way...

Please Login or Register  to view this content.