Hide/show shape on Sheet1 based on cell value in Sheet2?

[Guple]

Hi!

I manage to do what my title says with a VLOOKUP and VBA code for pictures. But this code only leets me view one picture at time. Therefore i´m looking for the same kind of solution for this shape. Any of you guys have any idea?

Thanks!! Guple

[patel45]

can you attach a sample file with notes ?

[Guple]

Below is CODE 1 which lets me choose which picture i want to show on sheet2 FROM SHEET1 (with VLOOKUP). This works great. But cannot be used with this specific action as it only lets ONE picture to be shown at a time. Therefore i´m looking for another macro to let me show/hide this specific shape "rectangle 1" on sheet2 from entering a specific value on SHEET1.

CODE 2 works like a charm with SHEET2 activated. But when SHEET1 is active and i enter the specific value in a cell (which is linked to D1 in SHEET2 (See code2)) the macro wont automatically update until i select sheet2 and run the macro in the VBA window.

Sorry for bad explanation, please ask if something is unclear!!

Thanks for your reply.

// Guple

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[Guple]

Anyone Please?

[patel45]

I asked for file, not only code

[Guple]

I removed the file!

[patel45]

I'm sorry but I did not understand anything about your workbook, your code and your goal

[HaHoBe]

Hi, Guple,

there is a formula in A5!H1. The event you have chosen to work will only get triggered once an entry is made into the cell it is monitoring but not if the value changes due to a formula.

I would suggest to work with Data/Validation for the input in start Range C3 in order to avoid typos.

Code could be reduced to

Please Login or Register  to view this content.

behind the sheet A5.

@patel45:

I asked for file, not only code

Sounds quite harsh to me - especially since you weren´t able to provide any hint/help.

Ciao,
Holger

[Guple]

Thanks for your help!!

I´ve added the data validation to start sheet c3 for a drop down list. This works great. THANKS!!



The code below also works great, but it does not make the shape hide/show until i manually go in to vba and manually run the code. Can i make excel to do this for me?

Please Login or Register  to view this content.

[Guple]

I was just kidding!!! Everything works great!! Thanks for your help!! AWESOME

[Guple]

I´m very thankful to all your help!! But i wonder if there is any way that i could use a drop down list instead of buttons?

My macro looks like this below, and can hide/show two different shapes linked to Cell "D17" and "D18". When Cell "D18" is true then shape99 appears, and when Cell "D17" is TRUE then shape100 appears. But as i want to add more shapes, and NOT more Buttoms, i´m interesting in a solution were i can use a drop down list. So for example when Cell "C20" have Value "shape1" then shape 1 appears, and when "C20" has value shape99 then shape100 appears.

Any ideas? I´m very thankful for your help!!!

Please Login or Register  to view this content.

Root: https://www.dropbox.com/s/8cwxgh6c8284e0l/program.xlsm

[HaHoBe]

Hi, Guple,

did you mean Buttons or Checkboxes?

Maybe like this:

Please Login or Register  to view this content.

Ciao,
Holger