What’s the best way to automatically update dimensions on a drawing image imported from a jpg to Exc

[Hank61]

I have a product drawing that’s saved as a jpg and will insert it into myspreadsheet. I want to be able to automatically update certain dimensions(e.g. length, width and height of product) based on values in my spreadsheet. What’s the best way to accomplish this?

I’ll have a form where the user specifies certain parameters of the product including length width and height and these values will be saved in my spreadsheet by customer. Depending on which customer is selected, I’d like to display dimensions on my product drawing image for that customer. Iwanted to place text boxes with this data on my product drawing picture but Excel only allows text boxes on forms, right?

Keep in mind I'm not trying to change the height of the picture. The picture should stay fixed. I want to change the value of a dimension that's displayed on the picture. So if cell A1 has 31" for the height, I want to show the value 31" on my picture where the height dimension is shown (i.e. picture is in background & 31" value is in the foreground). This applies to the other dimension values as well.

Any insight would be appreciated.

 

[GS]

I have a product drawing that’s saved as a jpg and will insert it into my

spreadsheet. I want to be able to automatically update certain dimensions
(e.g. length, width and height of product) based on values in my spreadsheet.
What’s the best way to accomplish this?

I’ll have a form where the user specifies certain parameters of the product
including length width and height and these values will be saved in my
spreadsheet by customer. Depending on which customer is selected, I’d like
to display dimensions on my product drawing image for that customer. I
wanted to place text boxes with this data on my product drawing picture but
Excel only allows text boxes on forms, right?

Keep in mind I'm not trying to change the height of the picture. The picture
should stay fixed. I want to change the value of a dimension that's
displayed on the picture. So if cell A1 has 31" for the height, I want to
show the value 31" on my picture where the height dimension is shown (i.e.
picture is in background & 31" value is in the foreground). This applies to
the other dimension values as well.

Any insight would be appreciated.

See if the app you used to create the drawing supports using Excel
design tables. If so then this will auto-create configurations based on
dims entered in the design table. Not a great benefit for only a few
configs, but a real life saver when a product item has many configs. (I
use SolidWorks and this is how I do it) When the dims change you can
toggle pic visibility via an event macro. (This is doing things the
hard way!<g>)

<The easy way...>
An approach I've used often for client worksheet utilities is to have
the CAD part (wireframe view, no hidden lines visible) OR CAD dwg
converted to GIF format and make it transparent so the dims (blank
values) are positioned over cells that contain formulas that update
when the ref cells are edited. The pic itself won't resize but the dims
will reflect actual size similar to what you see in a product catolog
with alpha labels and a sizes table below. Using a transparent pic
substitutes the actual dims in place of those alpha labels.

<The highly likely to be problematic way...>
You can put textboxes on the worksheet but I don't advise doing that in
this scenario.

--
Garry

Free uenet access at http://www.eternal-september.org
Classic VB Users Regroup
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion