ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] »ù®æ§R°£±i¼Æ¦Û°Ê§R°£

[µo°Ý] »ù®æ§R°£±i¼Æ¦Û°Ê§R°£

½Ð±Ð¦U¦ì¤j¤j
a1¬O»ù®æ
a2¬O±i¼Æ
¨â­ÓÀx¦s®æªº¼Æ¦r³£¬O­n¥Î¤â°Ê¿é¤J
½Ð°Ý¦³¿ìªk³]­p¦¨
a1¦pªG§R°£¤F
a2·|¦Û°Ê§R°£¶Ü¡H
ÁÂÁÂ

¦^´_ 1# coafort

½Ð´ú¸Õ¬Ý¬Ý¡AÁÂÁÂ
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$1" Then
If Target.Value = "" Then Range("a2").ClearContents
End If
End Sub

TOP

¦^´_  coafort

½Ð´ú¸Õ¬Ý¬Ý¡AÁÂÁÂ
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.A ...
samwang µoªí©ó 2021-11-22 09:51


ÁÂÁ¤j¤j
½Ð°Ý¤j¤j
¦]¬°§Ú¦³¦n´X­Ó¤u§@ªí
µM«á¨C¤@­Ó³£¦n´X¦C
¨º³o¼Ë­n«ç¼g©O
ÁÂÁÂ

TOP

ÁÂÁ¤j¤j
½Ð°Ý¤j¤j
¦]¬°§Ú¦³¦n´X­Ó¤u§@ªí
µM«á¨C¤@­Ó³£¦n´X¦C
¨º³o¼Ë­n«ç¼g©O
ÁÂÁÂ
coafort µoªí©ó 2021-11-22 10:01

¦]¬°§Ú¦³¦n´X­Ó¤u§@ªí >> ¥i¥H±Nµ{¦¡½X©ñ¦bThisWorkbook
µM«á¨C¤@­Ó³£¦n´X¦C >> ¤£¤ÓÁA¸Ñ·N«ä¡A¥i¥HªþÀÉ¥[¥H»¡©ú¡AÁÂÁÂ

TOP

¦]¬°§Ú¦³¦n´X­Ó¤u§@ªí >> ¥i¥H±Nµ{¦¡½X©ñ¦bThisWorkbook
µM«á¨C¤@­Ó³£¦n´X¦C >> ¤£¤ÓÁA¸Ñ·N«ä¡A¥i¥HªþÀÉ ...
samwang µoªí©ó 2021-11-22 10:28


´N¬O³o­Ó¸ê®Æ¤£¥u¦³¤@¦æ
¦Ó¬O¦³¦n´X¦Ê¦æ¥H¤W
¤ñ¤è
ÁÂÁ¤j¤j
123..png
2021-11-22 10:51

TOP

¦^´_ 5# coafort

½Ð´ú¸Õ¬Ý¬Ý¡AÁÂÁÂ
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
With Target
    If .Column = 1 Then
        If .Count > 1 Then Exit Sub
        If .Value = "" Then .Offset(, 1).ClearContents
    End If
End With
End Sub

TOP

¦^´_  coafort

½Ð´ú¸Õ¬Ý¬Ý¡AÁÂÁÂ
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Targe ...
samwang µoªí©ó 2021-11-22 11:26


½Ð°Ý¤j¤j~§Ú¦³10­Ó¤u§@ªí
¥u¦³1~6»Ý­n³o­Ó¥\¯à
½Ð°Ý­n«ç§ï©O¡H
ÁÂÁ¤j¤j

TOP

½Ð°Ý¤j¤j~§Ú¦³10­Ó¤u§@ªí
¥u¦³1~6»Ý­n³o­Ó¥\¯à
½Ð°Ý­n«ç§ï©O¡H
ÁÂÁ¤j¤j
coafort µoªí©ó 2021-11-22 12:09


Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
With Target
    If .Worksheet.Index > 6 Then Exit Sub
    If .Column = 1 Then
        If .Count > 1 Then Exit Sub
        If .Value = "" Then .Offset(, 1).ClearContents
    End If
End With
End Sub

TOP

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
With Target
    If ...
samwang µoªí©ó 2021-11-22 13:00


ÁÂÁ¤j¤j¡A¥i¥H¤F:D
½Ð°Ý¤j¤j¡A©Ò¥H¥u¦³1~6¦WºÙªº¤u§@ªí¤~·|¦³®ÄªG¨ä¥L¦WºÙ¤u§@ªí¤£·|µo¥Í®ÄªG¶Ü¡H
ÁÂÁ¤j¤j

TOP

¦^´_ 9# coafort


    ½Ð°Ý¤j¤j¡A©Ò¥H¥u¦³1~6¦WºÙªº¤u§@ªí¤~·|¦³®ÄªG¨ä¥L¦WºÙ¤u§@ªí¤£·|µo¥Í®ÄªG¶Ü¡H
>> ¬O«e­±1~6ªº¤u§@ªí¤~·|°õ¦æ¡AÁÂÁÂ

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¯Ê¤fªºªM¤l¡A¦pªG´«¤@­Ó¨¤«×¬Ý¥¦¡A¥¦¤´µM¬O¶êªº¡C
ªð¦^¦Cªí ¤W¤@¥DÃD