½Ð°ÝÀx¦s®æ¦P¤@®æªº³¡¤À¦rÁôÂÃ
- ©«¤l
- 396
- ¥DÃD
- 12
- ºëµØ
- 0
- ¿n¤À
- 425
- ÂI¦W
- 0
- §@·~¨t²Î
- Win10
- ³nÅ骩¥»
- Office 2016
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¤¤
- µù¥U®É¶¡
- 2013-7-2
- ³Ì«áµn¿ý
- 2024-8-23
  
|
¦^´_ 1# amber0083
n¸Õ¸ÕVBA¶Ü- Private Sub Worksheet_Change(ByVal Target As Range)
- Application.EnableEvents = False
- On Error Resume Next
- With Target
- If .Row > 1 And .Column = 1 Then '³]©w¢ÏÄæ(A2°_©l)¬°¼Ðªº
- If .Value <> "" Then
- .Value = Left(.Value, 5) & "***" & Right(.Value, 2)
- Else: .Value = ""
- End If
- End If
- End With
- Application.EnableEvents = True
- End Sub
½Æ»s¥N½X |
-
-
Book1.rar
(6.46 KB)
|
|
|
|
|
|