Prev: CDbl and "Type mismatch"
Next: Application or object defined error
From: Looping through on 25 Mar 2010 21:45
Does anyone know how to change a picture within a form based on a cell
reference in number?

IE if cell a3=4, image1 will have a different image activated than if cell
a3 returms a 7.

Any Help is appreciated.
Thanks
Pete
From: Peter T on 26 Mar 2010 06:52
Me.Image1.picture = img.Picture

where img refers to some other image control containing your picture
associated with the index in a3

This of course assumes you have already assigned pictures to a number of
image controls. these could be on a sheet or hidden in the userform (or even
a different userform).

Alternatively of course you could load from file
Me.Image1.Picture = LoadPicture(sFile)

where sFile refers to the path and name of the image file associated with
the index in a3

Regards,
Peter T


"Looping through" <Loopingthrough(a)discussions.microsoft.com> wrote in
message news:E1C404C4-114E-4389-BD88-30B9A7334D4D(a)microsoft.com...
> Does anyone know how to change a picture within a form based on a cell
> reference in number?
>
> IE if cell a3=4, image1 will have a different image activated than if cell
> a3 returms a 7.
>
> Any Help is appreciated.
> Thanks
> Pete


 | 
Pages: 1
Prev: CDbl and "Type mismatch"
Next: Application or object defined error