Hello everyone,

I'm fairly new to using VBA and I am attempting to create a dashboard utilizing certain topics/charts. The first sheet in the workbook is the dashboard and all of the raw data is on sheet 2, including the charts. I currently have a list box with a few topics. I am clueless as to how to activate/link the certain selections in the list box to display in the dashboard and when you click on another option, the new charts to display. Is this even possible?

I also used a data validation list because I wasn't sure what is easier, the list box or data validation. I was unable to attach the worksheet, but I will attach the screen shots. I would appreciate any advice.

Thank you in advance

DB.jpg

DB2.jpg

DB3.jpg