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"
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…