Excel VBA - InsertPicture
 

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

--
Message posted from http://www.ExcelForum.com

Excel VBA - InsertPicture
 

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 " wrote in
message ...
Hi

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

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

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

Does anyone know how to do this?

Thanks.


---
Message posted from http://www.ExcelForum.com/

Excel VBA - InsertPicture
 

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
--
Message posted from http://www.ExcelForum.com