Hi
I would do this in MS Visio (though the VBA implementation of Visio is
one of the worst and buggy things I've ever seen)

--
Regards
Frank Kabel
Frankfurt, Germany


KitKat wrote:
My problem:
Our company has several hundred UPC's numbers in an Excel
spreadsheet. Each number (obviously) corresponds to a office device
(i.e. monitor, keyboard, etc.). They want to be able to (when an UPC
number is entered) have a chart/graph/picture be drawn to include the
new device has been added to the inventory.

For example... if I have three monitors, a keyboard, and a mouse that
are new they want those added to this organizational chart. The UPC
numbers have some relivence, but not a lot. (i.e. All monitor UPC
numbers begin with "5"). Is there anyway, using VBA, to code a cell,
so that when a new UPC number is entered, Excel will draw a
box/shape/symbol to represent this addition? Would it be better to
use another MS program such as Access?