billyshears
Board Regular
- Joined
- Aug 29, 2013
- Messages
- 61
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.
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.