VBA Combo Box select Chart Display

[bigbeef105]

Hello all, I'm very new to VB.

I have a sheet with about 25 charts on it.
I want to have a combo box that lists names such as: "North America", "Latin America"
I want the items in the combo box to correspond to a specific chart so that selections will display the relevant chart.

I've used the following code to display a specific chart:

Set CurrentChart = Sheets("Regional Graphs").ChartObjects(1).Chart
Fname = ThisWorkbook.Path & "\temp.gif"
CurrentChart.Export Filename:=Fname, FilterName:="GIF"
Image1.Picture = LoadPicture(Fname)

But I'm unsure how to approach the much more complex task I've described above.

Appreciate any help you can provide.

Thanks,
Matt