Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
3.9k views
in Technique[技术] by (71.8m points)

excel - Select the combobox value according to the cell value

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"


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)
等待大神答复

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...