ComboBox populating problem

[Werner]

Hi,

I have 3 combobox. When I import values in my form, it copies in the linked cells the past choices I made in my combobox the last time I imported my data. when I have finished with my work in my form, I have an update macro that sends back to the source table the values that are in my linked cells. But When I do so, it changes the values in my linked cells into another one in the combobox and it saves the wrong choice. It always come back to the same wrong choice.

I think the problem is when I change the source sheet and come back to the Form sheet, it launches again the code to populate the comboboxes. Is there a way to execute the populating code of the combobox only at the opening of the workbook?
Thx!

Werner

This is the populating code in the working place in VBA :

Please Login or Register  to view this content.

[Werner]

A friend gave me the answer :

Please Login or Register  to view this content.