lpking2005
Board Regular
- Joined
- Mar 21, 2011
- Messages
- 140
I currently have a spreadsheet with about 15 command buttons,
i want each button to open a picture.
Is there a way to have a single userform with just a image box on it, pull the different pictures, depending on which button was pressed?
Instead of creating a userform for each picture.
I was going to use simple IF and ELSE statements on the userform initialize routine, but im still learning and didnt know how to tell it to recognise which button i pressed on the sheet.
Any help would be much appreciated.
i want each button to open a picture.
Is there a way to have a single userform with just a image box on it, pull the different pictures, depending on which button was pressed?
Instead of creating a userform for each picture.
I was going to use simple IF and ELSE statements on the userform initialize routine, but im still learning and didnt know how to tell it to recognise which button i pressed on the sheet.
Any help would be much appreciated.
