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

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

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

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

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.

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.