Excel VBA : Show Image from worksheet on Userform based on cell value

[Tanushri_Kothari]

Hi,

I have created userform, it should show picture in 'Image1' control based on B1 cell value. All pictures available on Sheet1 only. Please help.

 

[Al Mahmood]

Try this

 

[Tanushri_Kothari]

Try this

What exactly? Have you uploaded any file? I am not able to see anything apart from your text "Try this"

 

[Al Mahmood]

Oh! I don't know what went wrong. There should have a file. Anyways, check now...

 

[Tanushri_Kothari]

Oh! I don't know what went wrong. There should have a file. Anyways, check now...

Thanks so much, it is working. I saw the coding, actually my office computer profile is restricted, this macro will fail while coping the picture to the temp directory. Is there any way to just show Pictures without copying anywhere on the drive?

 

[Al Mahmood]

It's hard to make it, as an Image control does not support the way you are asking. Not sure whether it's possible or not. You can set a path that you have access.

 

[Tanushri_Kothari]

It's hard to make it, as an Image control does not support the way you are asking. Not sure whether it's possible or not. You can set a path that you have access.

ok, thanks.