Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing Thumbnail Pictures in a UserForm
Hi All,
I've got a UserForm that includes a thumbnail image. What I would like to do is have the image change based upon the values in two cell of the worksheet. When I show the UserForm it should display the image that corresponds to the particular cell value combination. e.g. When B17 and E12 are both 0 then when the UserForm is shown the image1 is displayed. When B17 = 0 and E12 = 1 then the UserForm displays image2 and so on. There are 15 possible conditions as B17 will only ever range from 0 to 2 and E12 from 0 to 4. The 15 image files (wmf) metafiles are located in the same folder as the Excel workbook. I suspect that I could do this using the ThisWorkbook.Path and the Image1.Picture - LoadPicture("File.wmf") but I hoping that there is a more efficient way than using 15 IF statements. Any tips would be much appreciated. Best regards, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
changing pictures according to cell value | Excel Discussion (Misc queries) | |||
Thumbnail ? | New Users to Excel | |||
Thumbnail pictures in cells don't sort with rest of row | Excel Discussion (Misc queries) | |||
Add pictures to UserForm at runtime | Excel Programming | |||
Assigning the name of a userform/control to a changing string | Excel Programming |