改这个 Private Sub ComboBox1_DropButtonClick() If ComboBox1.Value <> "" Then Dim Ir As Integer Dim rng As Range Dim 信息 As String On Error Resume Next With Sheets("信息") Label15 = .Cells(.Range("A2:A100").Find(ComboBox1, , , xlWhole).Row, 1) Label16 = .Cells(.Range("A2:A100").Find(ComboBox1, , , xlWhole).Row, 2) Label17 = .Cells(.Range("A2:A100").Find(ComboBox1, , , xlWhole).Row, 3) Label11 = .Cells(.Range("A2:A100").Find(ComboBox1, , , xlWhole).Row, 4) TextBox1 = Format(.Cells(.Range("A2:A100").Find(ComboBox1, , , xlWhole).Row, 5), "0.00") End With End If End Sub |