- ©«¤l
- 5923
- ¥DÃD
- 13
- ºëµØ
- 1
- ¿n¤À
- 5986
- ÂI¦W
- 0
- §@·~¨t²Î
- win10
- ³nÅ骩¥»
- Office 2010
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW°ò¶©
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2022-1-23
|
¦^´_ 3# owen06 - Dim Rng As Range, Ar()
- Private Sub UserForm_Initialize()
- Ar = Array(TextBox2, TextBox6, TextBox5, TextBox3, TextBox4) '±±¨î¶µ¸m©ó°}¦C
- 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 ¤£¦b²M³æ¤¤
- 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
½Æ»s¥N½X |
|