ComboBox range lost

[rukkie]

I have a excek workbook with 3 worksheets. On the first worksheets I
have 2 ComboBoxes defined to get input from the user for the macros.
The first time one is selecting a value of the ComboBox everything is
working fine and the macro is showing the result on the second sheet.
When one is going back to the first sheet with the ComboBoxes to give
some other input for the macros, the ComboBox appears empty, no values
can be selected . The only thing one can do is save the excel sheet and
reopen it againg and so one get again the values of the ComboBox range
to select from.

The ComboBoxes are created with the Control toolbox, the ListFillRange
is filled in via the "properties" and also a LinkedCell is defined. The
ListFillRange refers to cells which are on the same sheet as the
ComboBoxes.

Has anyone an idea what is going wrong here ?

 

[davesexcel]

Not sure why did you use the RowSource to populate the ComboBox??

 

[dmexcel]

this is supposed to read:
Not sure why;
did you use RowSource to populate the ComboBox