Update ComboBox after editing an item

[Menohavename]

Hi,

I hope you can help me spot the mistake in my code. I've been searching for a couple of days now but no luck.

Background: In my project, I have two categories of variables, "decision factors" and "decision criterion". Each factor can have criteria. For this reason, I saved them in a two-dimensional array decisionFactors(factor, criterion) in which (factor,0) represents the original factor name. Some factors are given at the start, then the user can add more factors or criteria. Additionally, there's an integer array NumberOfCriteria(factor) that obviously counts the number of criteria that are assigned to each factor. This all works perfectly fine. The problem comes with editing them. For this, I created the following user form:
temp.png
in which the content of the lower ComboBox depends on the selected factor in the upper one. On edit, the user can then enter a new name for the selected factor/criterion which then overwrites the value in the decisionFactors array. I checked this step with a MsgBox and the respective element does have the new value. The ComboBoxes, however, do not adopt the new value although I wrote a refresh routine. There seems to be a mistake within this routine but I cannot find it.

The code is as follows:

In the user form posted above (extract):

Please Login or Register  to view this content.

In the user form in which the new name can be entered:

Please Login or Register  to view this content.

Refresh routine:

Please Login or Register  to view this content.

PS: I'm well aware that my coding is probably far from elegant but the goal for now is simply to get it running.

I'd be very happy about any help, cheers!

[Leith Ross]

Hello Menohavename,

The chances of someone taking the time to recreate your project are slim to none. You will get a faster response by posting your workbook.

[AlphaFrog]

When you click the Edit button and update the decisionFactor array, you can also update the combobox at the same time. A combobox list is just another array. No need to Refresh the combobox.

(Not tested)

Please Login or Register  to view this content.

[Menohavename]

The chances of someone taking the time to recreate your project are slim to none. You will get a faster response by posting your workbook.

I thought, my mistake would be obvious to experienced VBA people only from looking at the code but I see the point. Will do so next time.

Please Login or Register  to view this content.

This works perfectly, thank you very much!