ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   popup immage (https://www.excelbanter.com/excel-programming/428173-popup-immage.html)

willemeulen[_50_]

popup immage
 

I was wondering if it's possible to let a picture popup in small window
when completing a form/sheet. The sheet I'm currently working on works
as follows:

Column A (material diameter) and Column B (shape code) are completed by
user, these values are used to index/lookup a formula from sheet 2.
The formula which is returned will need values to be completed to
calculate cut length (user determine's length of sections)
These value's are different for the shape as well it depends on the
user how large the shape is needed

It would be nice that after the shape code is filled in the user will
see a small diagram of the shape code being filled out and now can see
what value's A - E are.

Example

Material/diameter Shape code value A value B Value C
etc

Y8 35

The values A - E are depending on the shape and could be length, with,
radius, diameter etc. The shape codes are between 1 - 99 and have a wide
variety. One sheet will contain lots of rows (for certain drawing or
project) and will show the manufacturer material size, type and cut
length before bending the shape and gives a summary of each material's
total tonnage.


Thanks,

W;)


--
willemeulen
------------------------------------------------------------------------
willemeulen's Profile: http://www.thecodecage.com/forumz/member.php?userid=285
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=94414


royUK[_114_]

popup immage
 

You would need VBa to do this, maybe you could adapt this 'example'
(http://www.j-walk.com/ss/excel/tips/tip66.htm)


--
royUK

Hope that helps, RoyUK
For tips & examples visit my 'web site' (http://www.excel-it.com/)
------------------------------------------------------------------------
royUK's Profile: http://www.thecodecage.com/forumz/member.php?userid=15
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=94414



All times are GMT +1. The time now is 07:33 AM.

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