how can pass picture from cell in sheet to user form text box or image
how can pass picture from cell in sheet to user form text box or image
Copy picture:- "Ctrl + C"
Open Userform in design mode, Right click "Image Control", select "Properties", scroll down to "Picture", paste in row to right :- "Ctrl +V"
i need with cod please
is there any solution please?
perhaps you can provide mode detail about the real location of the picture.
Cells can not contain images. So the image might be the worksheet background image, or an image in the cells comment , or the fill of a shape.
The PastePicture file on Stephen Bullen's page may help.
http://www.oaltd.co.uk/Excel/Default.htm
If the picture is held in an activex control you should be able to use the Picture property.
i have tabel in sheet contain names degrees and pictures for the students
then i lookup for any name with index gived me the name and degree and the picture
i wont to pass what i looked (name , degree, pic) to the user form .....from the celles in the sheet that contain name degree and picture
i passed the name and the degree to the user form from sheet but i codnt with the pic
please help
i dont wont right path of pic in the drive ... i wont passed it from the table from cells
Last edited by lulua; 11-29-2014 at 06:04 AM.
So not images but name of the image file that is stored on disk? If so you can use the LoadPicture method to display the image via the .Picture property of the image control
so i cant pass picturs that was in cells ???
just with path name in drive?????
Post example as it is not clear, to me at least, where this image is being stored in.
You can get the image out of certain containers, such as shapes and activex controls, as I said and provided link for.
look file pass
i wont when i write n in textbox1 the pic that was in the tabel in cell j2 pass to user form
Uses the pastepicture code I suggested earlier
when i enter n or d its gived me the same picture
look columns h , i , j there was aformula that the textboxs depend on it
is there any solution??
The index value for the shape was wrong.
To avoid confusion you could rename the shapes to have non unicode names which you could then reference in the vba code.Please Login or Register to view this content.
thank u very very much Andy Pope
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks