View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Simon W Simon W is offline
external usenet poster
 
Posts: 5
Default Combo box is not listening to its linked cell

Hi,

I have a combo box (from the forms menu) that sets the value in its
linked cell just as it should.

However, if I change the value in the linked cell directly, the value
shown in the combo box window does not update to reflect the change.
I'm sure I have had combo boxes in the past (i.e. pre excel 2003)
where this wasn't a problem. I seem to get the same problem if I use a
VBA combo box from the controls menu.

Does anyone have any idea how to make sure the combo box and linked
cell keep in contact? I don't want to use the VBA combo boxes unless I
have to but is there something in their properties that can ensure
this two-way behaviour?

Thanks