|
发表于 2015-3-18 12:40
|
显示全部楼层
本楼为最佳答案
- Private Sub ComboBox28_Change()
- On Error GoTo err
- Dim rg ' As Range
- 'Set rg = Worksheets("参数表").Range("g2:i38")
- rg = Worksheets("参数表").Range("g2:i38").Value
- If Len(Me.ComboBox28.Text) > 0 Then
- TextBox16 = Application.WorksheetFunction.VLookup(Me.ComboBox28.Text, rg, 2, False)
- TextBox17 = Application.WorksheetFunction.VLookup(Me.ComboBox28.Text, rg, 3, False)
- End If
- Exit Sub
- err:
- MsgBox "出差所在地无效"
- Me.ComboBox28.Text = ""
- Me.TextBox16.Text = ""
- Me.TextBox17.Text = ""
- End Sub
复制代码 |
|