ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   image & picture (https://www.excelbanter.com/excel-programming/347538-image-picture.html)

Tom Rudski[_5_]

image & picture
 
I import a web picture into a Sheet and name the Shape (jpgname).
I currently use Hyperlink to activate the Picture,that works.

I have tried se;ecting & copying the Shape and pasting onto/inot a command
button or image. Get errors running teh code.

Can I make a command button or an image an paste the Shape(jpgname)
into/onto the control button or image's face? I have read the previously
posted responses to 'Picture' and they all Import a bmp file. I don't want
to import a bmp file just assign an existing Sheets Shape to some type of
command button/image.

TIA

Tom Ogilvy

image & picture
 
select the picture and do Edit=Copy

go to the image control in design mode and select propeties. click in the
picture property and do Ctrl+C

If you don't see it in the image control, then size it. You can do the
same with a commandbutton.

--
Regards,
Tom Ogilvy

"Tom Rudski" wrote in message
...
I import a web picture into a Sheet and name the Shape (jpgname).
I currently use Hyperlink to activate the Picture,that works.

I have tried se;ecting & copying the Shape and pasting onto/inot a command
button or image. Get errors running teh code.

Can I make a command button or an image an paste the Shape(jpgname)
into/onto the control button or image's face? I have read the previously
posted responses to 'Picture' and they all Import a bmp file. I don't

want
to import a bmp file just assign an existing Sheets Shape to some type of
command button/image.

TIA




Tom Rudski[_5_]

image & picture
 
Thanks for the quick response... it getting later over their for you...
Tried both 'Image' and 'Command button1'. It puts just a 'part' of the
picture into either object.

I tried 'auto sizing', fmPictureCenter, etc. All I get is 50% of the picture
in the 'Image' and a tall sliver of the Picture in the 'command button'. The
command button still has the 'text' showing, but only 10% of the picture next
to it.

Due to 10-14 pictures on a Sheet, I need only a Picture only (3) row high
(with the width squared off ). Also I tried 'record macro' and none of the
Paste commands showed the 'properties' commands. It appeasr to be a manual
operation.

Thanks

"Tom Ogilvy" wrote:

select the picture and do Edit=Copy

go to the image control in design mode and select propeties. click in the
picture property and do Ctrl+C

If you don't see it in the image control, then size it. You can do the
same with a commandbutton.

--
Regards,
Tom Ogilvy

"Tom Rudski" wrote in message
...
I import a web picture into a Sheet and name the Shape (jpgname).
I currently use Hyperlink to activate the Picture,that works.

I have tried se;ecting & copying the Shape and pasting onto/inot a command
button or image. Get errors running teh code.

Can I make a command button or an image an paste the Shape(jpgname)
into/onto the control button or image's face? I have read the previously
posted responses to 'Picture' and they all Import a bmp file. I don't

want
to import a bmp file just assign an existing Sheets Shape to some type of
command button/image.

TIA






All times are GMT +1. The time now is 11:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com