Create an image upload form in excel VB

[jakeembx]

hi everyone,
I'm creating a form in excel vb that will allow the user to input data about students, however images are required for student profiles as a profile picture. Is it possible to create a upload form so that the user can upload profile pictures without having to manually insert images in to excel???
Thank you

[tony h]

yes.

The simplest (which isn't simple) is to create a form which allows a file path and name to be entered.
You could write a browse and file picker.
If you have an attached camera you should be able to capture a picture.

You can display the image on the form

But to save it in the spreadsheet you will need to create something to hold the picture eg a drawing object and set the image property to the image.

[jakeembx]

yes.

The simplest (which isn't simple) is to create a form which allows a file path and name to be entered.
You could write a browse and file picker.
If you have an attached camera you should be able to capture a picture.

You can display the image on the form

But to save it in the spreadsheet you will need to create something to hold the picture eg a drawing object and set the image property to the image.

Thank you for the reply,

I will look more into a file path thank you so much

PS would this mean I would have to set up a particular folder for images to be inserted from???

[tony h]

This code you can run to see how the file picker dialog works. If you want to use something like this then think about how exactly you might want the process to work. Then post with an update

Please Login or Register  to view this content.

[jakeembx]

Thank you for your support, really appreciate it!!