excel - Select the combobox value according to the cell value

Question

From the "auxiliary table" sheet, load the values into the combobox via the additem. Each line has 2 values. The selected item in the combobox is the 1st value "machine name" and the 2nd value "machine speed" is written in the cell in the "data" sheet. This value is written to another "data list" sheet via the macro, as a new row of values. I have another macro that, after selecting a row in this "data list" worksheet, overwrites that row in the "data" worksheet. And here I would need to update the selected combobox item "machine name", according to the current value "machine speed" in the "data" sheet.

over:

worksheets("data").ComboBox_Machine.Value = worksheets("data").Range("cmtSpeedMachine").Value

to insert "machine speed" but I need to selected "machine name"

Answer 1

等待大神答复