Insert image by clicking on Usreform Image1
 

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....

Insert image by clicking on Usreform Image1
 

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....

Insert image by clicking on Usreform Image1
 

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....