How would i go about inserting an image to a userform by clicking on the Image1?

I need a prompt to select the image then size it to the Image contol on the userform??

Corey....

Not sure if this will work though.

What i am doing is storing data on a single line in sheet2.
The values(say all in Row1) are input into sheet1 for viewing ina dressed layout.
Or the user can input new values into a userfrom, then this new data is placed into a new line in
sheet2.
But on the userfrom i have 2 image controls, where i want to have the user select and insert 2
pictures.

Then when the commandbutton is clicked the data (including images) are placed into a single row in
sheets for storing and later viewing or editing.
But can an image be stored IN a CELL?

I need some advice on how to tackle the image storage succefully, including sizing to minimise th
efile size in time.

Corey....
"Corey" wrote in message ...
How would i go about inserting an image to a userform by clicking on the Image1?

I need a prompt to select the image then size it to the Image contol on the userform??

Corey....

hi,
Pictures cannot be stored in cells. sorry.
see these site...
http://database.ittoolbox.com/docume...ng-macro-5027#
http://support.microsoft.com/default...b;en-us;213732
http://www.mrexcel.com/archive/Controls/23430.html

might get you going.
Regards
FSt1

"Corey" wrote:

Not sure if this will work though.

What i am doing is storing data on a single line in sheet2.
The values(say all in Row1) are input into sheet1 for viewing ina dressed layout.
Or the user can input new values into a userfrom, then this new data is placed into a new line in
sheet2.
But on the userfrom i have 2 image controls, where i want to have the user select and insert 2
pictures.

Then when the commandbutton is clicked the data (including images) are placed into a single row in
sheets for storing and later viewing or editing.
But can an image be stored IN a CELL?

I need some advice on how to tackle the image storage succefully, including sizing to minimise th
efile size in time.

Corey....
"Corey" wrote in message ...
How would i go about inserting an image to a userform by clicking on the Image1?

I need a prompt to select the image then size it to the Image contol on the userform??

Corey....