Inserting photo into userform using a variable

[billyshears]

My userform has a photo area.

I want the userform to operate so when I click the button to bring it up, the photo that comes up with the userform to be based on a cell value on the active worksheet.

For instance, when Cell A1 = 1, I click a button and the userform brings up Photo1.jpg and shows a picture of a flower

When Cell A1=5, the userform brings up Photo5.jpg and shows a picture of a lion

Any answers are much appreciated.

 

[billyshears]

I believe I am close with this

UserForm1.Image1.Picture = LoadPicture("C:\Users\mambr\OneDrive\Documents\Owen Game\Picture" & "Range("C5").Value" & ".jpg")

but part of this must be off. It works if I simply use the full path, but not with trying to do the variable

 

[richh]

The range portion seems off. It's not tied to a worksheet and it's in quotes. I'd try to change that part to

Application.thisworkbook.worksheets("SheetName").cells(5,3).value