ComboBox changes text when switching tabs

[Gabor G]

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

 

[Tom Ogilvy]

To the best of my knowledge, a combobox from the control toolbox toolbar
does not have a caption - do you mean the value of the combobox changes.
that can be changed with code or it can be changed by linking it to a cell
(or by manually changing the selection). If you have code for changing its
value, I would look there. If you change the listindex, that could be a
contributor.

 

[Gabor G]

Tom, I meant the value of the combobox.

The LinkedCell is set : V20
ListFillRange is set: X1:X19
Everything seems fine there.

I don't have a code changing the value of the combobox, however I tried to
jig one up to change it BACK to what it should be.
There is another code changing the source range of the two graphs using a
Select Case instruction based upon the value of the ComboBox..

Wait a minute, there is something funny here:
I opened the same file on another computer (Excel'97) and it works fine
first, but then Excel hangs after playing with the file for some time. It's
either a failure in excel.exe, or in MSO97.dll. This is the case on both
pc-s by the way.
Maybe I do something very wrong in some of the codes...

Not sure what to do next.

Gabor

 

[Tom Ogilvy]

I would remove the linkedcell and listfillrange and manage the combobox
just with code and see if that helps.