ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   INSERT OBJECT BASED ON CELL REFERENCE (https://www.excelbanter.com/excel-worksheet-functions/152482-insert-object-based-cell-reference.html)

Gwen's Rose

INSERT OBJECT BASED ON CELL REFERENCE
 
Have created a purchase order form that I would like to change company logo's
by simply typing in a reference ie "I" to bring up a company logo vs manually
dragging the picture to it's appropriate spot. Need it to change the company
logo by changing the reference ie "A".

bj

INSERT OBJECT BASED ON CELL REFERENCE
 
you will probably need to write a macro to do this.

"Gwen's Rose" wrote:

Have created a purchase order form that I would like to change company logo's
by simply typing in a reference ie "I" to bring up a company logo vs manually
dragging the picture to it's appropriate spot. Need it to change the company
logo by changing the reference ie "A".


Gwen''s Rose

INSERT OBJECT BASED ON CELL REFERENCE
 
Was afraid of that. Never created a macro. Every time I pick up a book on
it, I get lost. Yet I can do some pretty cool stuff with excel. Need someone
to walk me through it.

"bj" wrote:

you will probably need to write a macro to do this.

"Gwen's Rose" wrote:

Have created a purchase order form that I would like to change company logo's
by simply typing in a reference ie "I" to bring up a company logo vs manually
dragging the picture to it's appropriate spot. Need it to change the company
logo by changing the reference ie "A".



All times are GMT +1. The time now is 01:42 AM.

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