- ©«¤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
        
|
¦^´_ 1# gn00487767
¸Õ¸Õ¬Ý- Option Explicit
- Option Base 1
- Private Sub CommandButton1_Click()
- Ex
- End Sub
- Private Sub TextBox1_Change()
- Ex
- End Sub
- Private Sub Ex()
- Dim Rng As Range, Ar, i As Integer
- Ar = Array([C3], [G3], [C5], [G5], [C7], [C9])
- Set Rng = Sheets("¸ê®Æªí").Range("A:A").Find(WHAT:=TextBox1, LOOKAT:=xlWhole)
- For i = 1 To UBound(Ar)
- If Not Rng Is Nothing Then
- Ar(i).Value = Rng.Offset(, i)
- Else
- Ar(i).Value = ""
- End If
- Next
- End Sub
½Æ»s¥N½X |
|