Problems with combo boxes

  • Thread starter Thread starter Jody
  • Start date Start date
J

Jody

I have a spreadsheet with lots of combo boxes that were
working fine until yesterday. The linked cell is supposed
to update the combo box and visa-versa, but when the value
in the linked cell changes, the combo box is not being
updated. Why is this happening all of a sudden? Is it
some options setting? Help!
 
Jody,

A couple of suggestions:

Have you double checked the settings of the combo box, is it still linking
to the cell you think it should be linking to?

Might the calculation of your worksheet be switched to Manual recalculation
in stead of automatic? (check Tools/Options/Calculation)

Might your combo box be referring to a Named range, which has moved to a
different address? (check Insert / Name / Define for the referral of the
named range the combo box is linking to)

Any luck in solving the issue?

Kind regards,

Marcel Kreijne
Quandan - Steunpunt voor spreadsheetgebruikers
(Quandan - dutch supportsite for spreadsheetusers)
www.quandan.nl
 
Thanks, Marcel, those were all great suggestions, the only
problem is that I checked all of the things you mentioned
and they are not the problem -

- The cell that it is linked to is updated properly when
the selection is made using the box. It's just that when
the cell is updated, the box is not being updated
accordingly.

- The manual recalculation is not set on

- I am not using named ranges.

I discovered, however, that if I change one of the
properties, for example the number of drop down lines,
that it will then start to work properly. The problem is
that this spreadsheet has hundreds of combo boxes so I
created a macro to change them all.

I still need to know why this happened because this
spreadsheet will be distributed to a lot of users and I
don't want it to suddenly happen again while they are
using it.

Thanks again! - Happy New Year!
 
Jody,

Could it be that no other cel is calculating with the value in the
linking cel and that this is the only change you made (change the
value of the linked cell)? In that case it might be that The dependency
of the combobox to the linked cel does not trigger Excel that a
recalculation is required... You might want to force Excel to recalculate
the sheet by placing an 'instable' formula in a cell on the sheet. I'd
suggest
you'd use the function =NOW() to do so, that won't look odd to anyone
I assume...

Kind regards,

Marcel Kreijne
Quandan - Steunpunt voor spreadsheetgebruikers
(Quandan - dutch supportsite for spreadsheetusers)
www.quandan.nl
 
Back
Top