- ©«¤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
![2017 Âû¦~¥þ¶Ô¼ú³¹ 2017 Âû¦~¥þ¶Ô¼ú³¹](images/common/ji.gif) ![2016µU¦~¥þ¶Ô¼ú³¹ 2016µU¦~¥þ¶Ô¼ú³¹](images/common/hou.gif) ![2015¦Ï¦~¥þ¶Ô¼ú³¹ 2015¦Ï¦~¥þ¶Ô¼ú³¹](images/common/yang.gif) ![2014°¨¦~¥þ¶Ô¼ú³¹ 2014°¨¦~¥þ¶Ô¼ú³¹](images/common/ma.gif) ![2013³D¦~¥þ¶Ô¼ú³¹ 2013³D¦~¥þ¶Ô¼ú³¹](images/common/she.gif) ![2012Às¦~¥þ¶Ô¼ú³¹ 2012Às¦~¥þ¶Ô¼ú³¹](images/common/long.gif) ![½×¾Â°^Äm¾±³¹ ½×¾Â°^Äm¾±³¹](images/common/medal5.gif) ![¼ö¯P°Ñ»P¾±³¹ ¼ö¯P°Ñ»P¾±³¹](images/common/medal7.gif) ![2011¨ß¦~¥þ¶Ô¼ú³¹ 2011¨ß¦~¥þ¶Ô¼ú³¹](images/common/tu.gif)
|
¦^´_ 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 |
|