change picture with formule

Speedkiller1975

New Member
Joined
Mar 5, 2014
Messages
2
Hallo,

i have a question i have a Cell where can stand Vertical or Horizontal.

i have to pictures with a image one Vertical and one Horizontal.

is it possible to bring the right picture in front of the other.

is this possible with an formula.



i can do this with VBA but in need to use formulas

thanks

Mark
 

Some videos you may like

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

pgc01

MrExcel MVP
Joined
Apr 25, 2006
Messages
19,884
Hi Mark

First, I'm not sure I understand correctly.

This is what I understood:
- you have some names and for each name a corresponding picture
- there's a cell where you write one of those names, and in another part of the worksheet the corresponding picture is displayed

Example

You use cell B2 to write the name. In another part of the worksheet, for ex. overlapping D2:E5, the corresponding picture is displayed.
Each time you change the name in B2 the picture updates.

Issues:

Do the names of the pictures ("Horizontal" and "Vertical") reflect the proportions height/width or are just names that have nothing to do with the dimensions?

You can have a solution without vba, just with formulas, but in that case the dimensions and position of the pictures displayed are fixed.
 

Speedkiller1975

New Member
Joined
Mar 5, 2014
Messages
2
Hallo

I have done it in VBA but like to do it without macros I did it like this:

Have picture2 and picture3 oboe email each other. When cell b2 has has value horizontal picture3 will Go to the background, if cell b2 has value vertical picture2 will go to the background.

I hope you understand it now

Thanks

Mark
 

Watch MrExcel Video

Forum statistics

Threads
1,123,364
Messages
5,601,187
Members
414,434
Latest member
Riyen

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top