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 |
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