- 帖子
- 5923
- 主題
- 13
- 精華
- 1
- 積分
- 5986
- 點名
- 0
- 作業系統
- win10
- 軟體版本
- Office 2010
- 閱讀權限
- 150
- 性別
- 男
- 來自
- 台灣基隆
- 註冊時間
- 2010-5-1
- 最後登錄
- 2022-1-23
        
|
4#
發表於 2014-3-27 15:49
| 只看該作者
回復 3# owen06 - Dim Rng As Range, Ar()
- Private Sub UserForm_Initialize()
- Ar = Array(TextBox2, TextBox6, TextBox5, TextBox3, TextBox4) '控制項置於陣列
- With Sheet1
- Set Rng = .[A3]
- ComboBox1.RowSource = .Range("a3:a" & [a65536].End(3).Row).Address
- ComboBox2.RowSource = .[iv65533:iv65536].Address
- End With
- End Sub
- Private Sub ComboBox1_Change()
- Dim sel(), i As Integer
- sel = Array(2, 4, 9, 12, 13)
- With ComboBox1 '.ListIndex = -1 不在清單中
- For i = 0 To UBound(Ar)
- Ar(i).Text = IIf(.ListIndex > -1, Rng.Offset(.ListIndex, sel(i) - 1), "")
- Next
- End With
- 'TextBox2 = Application.VLookup(sel, Sheet1.[a3:s65536], 2, False)
- 'TextBox6 = Application.VLookup(sel, Sheet1.[a3:s65536], 4, False)
- 'TextBox5 = Application.VLookup(sel, Sheet1.[a3:s65536], 9, False)
- 'TextBox3 = Application.VLookup(sel, Sheet1.[a3:s65536], 12, False)
- 'TextBox4 = Application.VLookup(sel, Sheet1.[a3:s65536], 13, False)
- End Sub
複製代碼 |
|