If statement, TRUE , FALSE => If true show picture 1 else show picture 2

**uaeXuae** · 12-07-2007, 12:37 AM

Hello guys this is my 1st post im working on a mechanical project , I need to do some modifications to my XLS file that i aint familair with.

\1

**uaeXuae** · 12-07-2007, 02:23 AM

Does anyone know how is that done or does anyone have an example file ?

**uaeXuae** · 12-07-2007, 02:27 AM

Does anyone have any example on how it is done thanx ..

**shg** · 12-07-2007, 02:31 AM

Threads merged. Please do not post the same question in two forums.

**Paul** · 12-07-2007, 02:33 AM

Hi uae,

You cannot hide/show pictures with worksheet formulas. You would need to use vba code to do so.

Something like the following sounds close to what you're after:

Please Login or Register  to view this content.

**uaeXuae** · 12-07-2007, 02:41 AM

Thanx buddy, here is an example of what im trying to do:

http://aycu36.webshots.com/image/348...0572870_rs.jpg

Please find the XLS file from the basket below.

**Paul** · 12-07-2007, 03:01 AM

Try adding this code to your Sheet1 code:

Please Login or Register  to view this content.

Your picture's names in Excel are 'Picture 9' and 'Picture 13' (if you click on them, you'll see their names in the Name box (above and to the left of cell A1).

**uaeXuae** · 12-07-2007, 03:31 AM

Thanx a million + a million More it worked :-)

**uaeXuae** · 12-07-2007, 01:22 PM

Hey buddy is there an easier way to know the exact location after moving the pictures around. I play with the values so most of the time its ( trial and error). If you have an easier way to retrieve the .top & .left value please share.

Please Login or Register  to view this content.

Thanx in advance.

**Paul** · 12-07-2007, 01:30 PM

Hi uae,

Place the following code into your workbook:

Please Login or Register  to view this content.

Then, to find a specific image's location:
1. Click on the image to see it's actual name (in the Name box), e.g. Picture 13
2. In cell A1, type that name as shown, including spaces
3. Press ALT+F8 and select the 'getPicLocation' macro.

A message box will pop up with the Top and Left values of that image. If you move the image and then run the macro again, it will tell you the new location. (If you don't want to use cell A1, use another cell but change the code to reflect that.)

Hope that helps.