Re: If Image. . .?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: "Nigel" <nigel-sw@xxxxxxxxxxxxxxxxxx>
Date: Mon, 13 Jun 2005 08:27:18 +0100

Images placed on a work*** are part of the SHAPES collection. For example
the two shapes called Picture 1 and Picture 2 have been placed on top of
each other on the same ***. Either is visible depending on the value of
cell A1.

If Range("A1") = "Sunny" Then
Active***.Shapes("Picture 1").Visible = True
Active***.Shapes("Picture 2").Visible = False
Else
Active***.Shapes("Picture 1").Visible = False
Active***.Shapes("Picture 2").Visible = True
Endif

--
Cheers
Nigel

"Fable" <Fable.1qjwmb_1118642707.1614@xxxxxxxxxxxxxxxxxxxxx> wrote in
message news:Fable.1qjwmb_1118642707.1614@xxxxxxxxxxxxxxxxxxxxxxxx
>
> Greetings,
>
>
> I'm trying to recreate a weather chart via excel, I got excel
> populating the information from a URL. I would like to know if it's
> possible to have a picture / image change according to a word.
>
> Example: if the word Sunny is in cell B2 then a Sun Icon would appear
> in cell A1, but if it says Cloudy then the Cloudy Icon appears.
>
> Thanking you in advance,
>
>
> --
> Fable
>
>
> ------------------------------------------------------------------------
> Fable's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=2185
> View this thread: http://www.excelforum.com/showthread.php?threadid=378464
>

.

References:
- If Image. . .?
  - From: Fable

Prev by Date: RE: Run Excel Macro from Command Line
Next by Date: Re: Macro to capture cell value then use it for a relative range s
Previous by thread: If Image. . .?
Next by thread: RE: If Image. . .?
Index(es):
- Date
- Thread