How to programmatically change the value of a ComboBox and accept it?

Question

Visual Basic

When we launch a form, select something in the list and click on it, it is applied. But this is provided that we did everything manually. How can I do the same using VBA? If you write the following: Then it will simply change the value, but there will be no this "Accept change" effect. And you need to accept them because the subsequent elements of the form change, which depend on the value selected in the combobox
ComboBox1.Value = 4

Answer 1

Try this ComboBox1.ListIndex = 3 . The index of the first element is 0, so if you want to select the fourth element in the list, you need to specify 3.