Excel VBA - InsertPicture

[Abdul Rahuman]

Hi

In my workbook, I have some drawings in one worksheet. I want to cop
this drawings to the Active worksheet when I change the content of
ComboBox.

I want to replace the old drawing to new one according to the data i
Combobox.

I tried this with the drawings in seperate gif,bmp or jpeg file. But
want to take drawings from the same workbook's worksheet.

Does anyone know how to do this?

Thanks

 

[Bob Phillips]

Hi Abdul,

Here is a previous thread on this topic.

http://tinyurl.com/2eele


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Abdul Rahuman]

Thanks Mr Bob Philips

But I am not familiar in Macro for Data Validation. So I used Combo Bo
from Visual Basic Toolbar.

I attach herewith my sheet and code. This inserts picture from seperat
Gif file, and it overwrites the previous one.

But my intention is to take picture from the same workbook's othe
sheet, and to replace with the previous one.

Could you help me to do this?

Thanks

Attachment filename: shoe pictures.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=50341