Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations waross on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Autoselection of bitmap image

Status
Not open for further replies.

kstaylor

Mechanical
Jan 8, 2001
86
US
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
 
Replies continue below

Recommended for you

Without actually writngthe macro for you, here's some clues to get you started!

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
 
Quickly snipped together an example for you. See at
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.
 
Thanks, Mutt! This is exactly what I was looking for.
 
I posted a similar question some time ago and got the answer from this forums top expert jproj.

See thread770-29530

It works excellent

Regards
Mogens
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top