Autoselection of bitmap image
Autoselection of bitmap image
(OP)
Does anyone know how to automatically select and display a bitmap image based on a cell value in XL?
I have bitmap images of several different configurations of a design. I want to display a specific bitmap image in the spreadsheet based on a user selection from a menu. Currently I have to add the bitmap in the spreadsheet manually. Is there any way to automate this?
KST
I have bitmap images of several different configurations of a design. I want to display a specific bitmap image in the spreadsheet based on a user selection from a menu. Currently I have to add the bitmap in the spreadsheet manually. Is there any way to automate this?
KST





RE: Autoselection of bitmap image
Load up all images, even one on top of the other - in autostart macro make images hidden except for already selected item in menu.
In the menu, allow user to say select image from a drop down menu or similar. When user changes, activates macro to make the relevant image visible thru VBasic by unhidng the one and hiding the other.
I've used this for overlaying utility piping systems over a plotplan for user to view as required. Let me know if need help with coding on steve@langleyventures.co.za
RE: Autoselection of bitmap image
Not pretty but you'll get the idea. Drew 3 pics on the sheet and named them flash, smile, sunburst. Used forms to add in a drop down box which is has macro assigned to it. Selected pic is referenced in cell A7 (dropdown link) - usually I tuck it behind the drop down box or on a hidden sheet so the user doesn't see it. Picture options are listed below - again I usually do on another hidden sheet.
Macro is straight forward I think. Sure you'll be able to fine tune for your purposes!
Happy coding - Mutt.
RE: Autoselection of bitmap image
RE: Autoselection of bitmap image
See Thread770-29530
It works excellent
Regards
Mogens