insert diagram
 

hello all,
i would like to know if it is possible to have a diagram (image) inserted
into a worksheet if a value is entered into a specific cell? if so what kind
of image does it need to be? i have these diagrams drawn in AutoCad.
--
Thank You in advance, Brian

insert diagram
 

You can insert AutoCad drawings directly into Excel by doing INsert Object
CreateFromFileTab ....then follow the menus. As for it appearing there on
entering a certain value in a certain cell......that would take a
change-event macro. You could have Drawing Numbers/FileNames in cells as
hyperlinks and just click on them .......or you could insert .jpg's into
CommentBoxes to pop-up as the cell is moused-over. Tell us a little more
about what you're wanting to do, and we might can help more...........

Vaya con Dios,
Chuck, CABGx3



"Brian" wrote:

hello all,
i would like to know if it is possible to have a diagram (image) inserted
into a worksheet if a value is entered into a specific cell? if so what kind
of image does it need to be? i have these diagrams drawn in AutoCad.
--
Thank You in advance, Brian

insert diagram
 

your response has helped in many ways. it has triggered the mind. thank you
very much!
--
Brian


"CLR" wrote:

You can insert AutoCad drawings directly into Excel by doing INsert Object
CreateFromFileTab ....then follow the menus. As for it appearing there on
entering a certain value in a certain cell......that would take a
change-event macro. You could have Drawing Numbers/FileNames in cells as
hyperlinks and just click on them .......or you could insert .jpg's into
CommentBoxes to pop-up as the cell is moused-over. Tell us a little more
about what you're wanting to do, and we might can help more...........

Vaya con Dios,
Chuck, CABGx3



"Brian" wrote:

hello all,
i would like to know if it is possible to have a diagram (image) inserted
into a worksheet if a value is entered into a specific cell? if so what kind
of image does it need to be? i have these diagrams drawn in AutoCad.
--
Thank You in advance, Brian

insert diagram
 

You're welcome, happy to help, and thanks for the feedback.
Another thing you might consider, is Jim Cone's great Add-in called
ListFiles. It's available at

http://www.realezsites.com/bus/primi...e/products.php

With it, you can interrogate a directory of AutoCad files and transfer a
list of them into Excel with automatic Hyperlinks. Those hyperlinks can be
just clicked on and the file will open in AutoCad.........pretty nifty.



Vaya con Dios,
Chuck, CABGx3



"Brian" wrote:

your response has helped in many ways. it has triggered the mind. thank you
very much!
--
Brian


"CLR" wrote:

You can insert AutoCad drawings directly into Excel by doing INsert Object
CreateFromFileTab ....then follow the menus. As for it appearing there on
entering a certain value in a certain cell......that would take a
change-event macro. You could have Drawing Numbers/FileNames in cells as
hyperlinks and just click on them .......or you could insert .jpg's into
CommentBoxes to pop-up as the cell is moused-over. Tell us a little more
about what you're wanting to do, and we might can help more...........

Vaya con Dios,
Chuck, CABGx3



"Brian" wrote:

hello all,
i would like to know if it is possible to have a diagram (image) inserted
into a worksheet if a value is entered into a specific cell? if so what kind
of image does it need to be? i have these diagrams drawn in AutoCad.
--
Thank You in advance, Brian

insert diagram
 

Brian

See JE McGimpsey's site for adding pictures based on cell value.

http://www.mcgimpsey.com/excel/lookuppics.html


Gord Dibben MS Excel MVP

On Wed, 10 Jan 2007 04:51:01 -0800, Brian
wrote:

hello all,
i would like to know if it is possible to have a diagram (image) inserted
into a worksheet if a value is entered into a specific cell? if so what kind
of image does it need to be? i have these diagrams drawn in AutoCad.

insert diagram
 

hey this works also. thanks GD
--

Brian


"Gord Dibben" wrote:

Brian

See JE McGimpsey's site for adding pictures based on cell value.

http://www.mcgimpsey.com/excel/lookuppics.html


Gord Dibben MS Excel MVP

On Wed, 10 Jan 2007 04:51:01 -0800, Brian
wrote:

hello all,
i would like to know if it is possible to have a diagram (image) inserted
into a worksheet if a value is entered into a specific cell? if so what kind
of image does it need to be? i have these diagrams drawn in AutoCad.