Combobox not reflecting linked cell value

i have 3 comboboxes in a sheet, and one combobox change code that will trigger another cell's value based on what is selected in combobox1.
After all fields are filled in, I have a macro that will clear all constants, including the linked cells of all 3 comboboxes. However, whenever this happens, only 1 combox will be blank (reflecting its blank linked cell), but the other 2 will still have text in them despite their linked cells being blank. Any ideas?

Hi thanks for the reply, but i managed to work around it.

I was using ActiveX.

I found out that if I put the code in Combobox1_change(), comboxes 2 & 3 will not update their values from the linked cell.

If I put the code only in Combobox2_Change(), only combobox 3 will not update.

So I just shifted the code to Combobox3_Change()

Did the job, even though I have no idea why.

Thanks anyway!