Combobox not working properly

Hi all,

I have three comboboxes (active-x) on a worksheet (MS Office 2013). For each of them I have a "Private Sub ComboBox(1/2/3)_Change()" procedure.

When I select a line from combobox1, then for each line of code in the change() code for combobox1 the procedures for combobox2 and combobox3 are executed.

When I select a line from combobox2, then for each line of code in the change() code for combobox2 the procedures for combobox3 and combobox2 (the very one I clicked) are executed.

When I select a line from combobox3, then for each line of code in the change() code for combobox3 the procedures for combobox3 (the very one I clicked) and combobox2 are executed.

This seems to be a weird phenomenon.

Does anyone have a clue what causes this behaviour?

Any help will be greatly appreciated.

Thank you in advance.

Best regards

Hans

Additional question:

From a previous version I seem to remember that there used to be a kind of menu tree structure for all the methods and properties for any object. How do I invoke this?

Hi Norie,

Thanks for your quick reply. The boxes are populated via named areas and the references are given in Properties.ListFillRange.

Unfortunately I am not at my Windows PC. I am right now sitting at a Mac.

The simple worksheet is about tracking activities. A command button inserts a line at the top of the sheet and populates cells with date and time. For the type of activity there are three comboboxes:

- one for my own projects
- one for projects I have to work on that are not my own
- interruptions like phone calls, meetings etc.

The code in the change() procedures is quite simple:

- store the selected line of a combobox in the corresponding cell and clear the other two as in

range ("f2").value = combobox1.value
range ("g2"),value.clear
range ("h2"),value.clear

There isn't more to it.

If it helps I can attach the workbook tomorrow.

Thanks again for thinking into this.

Best regards

Hans