LadyScot101
New Member
- Joined
- Feb 6, 2022
- Messages
- 2
- Office Version
- 2010
- Platform
- Windows
Hello All,
I've never made a dashboard before, but I have 1000s of alumni pictures that I want to have the user push a button on an Excel Dashboard to either show all the pictures in a folder, or By Name, By Student ID, By Year, or By Function (such as Football, etc). I have a Command Button for each of those. I just need to code them in VBA. If the user pushes the All Pictures Button, it just opens up all the pictures in the folder. If the users pushes the By Name, a question pops up asking which name and it searches all the pictures for the name and it opens up the picture on the screen that was requested. Same for all the other buttons. How do I code each Command Button to do what I want them to do?
Any help in this would be greatly appreciated! Thanks!
I've never made a dashboard before, but I have 1000s of alumni pictures that I want to have the user push a button on an Excel Dashboard to either show all the pictures in a folder, or By Name, By Student ID, By Year, or By Function (such as Football, etc). I have a Command Button for each of those. I just need to code them in VBA. If the user pushes the All Pictures Button, it just opens up all the pictures in the folder. If the users pushes the By Name, a question pops up asking which name and it searches all the pictures for the name and it opens up the picture on the screen that was requested. Same for all the other buttons. How do I code each Command Button to do what I want them to do?
Any help in this would be greatly appreciated! Thanks!