Guys, I'm struggling with a ComboBox control: it changes it's content, or
caption, or text every time the user switches to another sheet and switches
back to the sheet where the ComboBox is. It is rather awkward, because
changing the ComboBox changes two graphs on the sheet "Report". The ComboBox
acts like a heading to the graphs, whilst the second sheet "List" contains
the details for the graphs.

First the user selects a department name from the combobox, that calls the
data of that department to appear on the graphs.
Then the user clicks a field on the "Report" , that leads him/her to the
sheet "List", where she/he can view the detailes of the selected department
with a help of a UserForm.

When the user goes back to the sheet "Report" guess what, the departmental
name is changed in the ComboBox, but the ghaph still shows the data of the
previously selected department: confusion starts, people call, etc.

Anyway, the ComboBox changes the caption and I have no clue how to control
it.

This is an Excel 2000 program.

I'd appreciate your suggestions...

Gabor