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

[µo°Ý]½Ð°Ý¦p§@¨ì«ö¤@¤UÀx¦s®æ¡A´N¯à§PÂ_¥X©Ò¦b¦ì¸mªº¦WºÙ

¦^´_ 1# abbay262

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Dim xR
    xR = Array("ABC", "DEF", "GHI")
    For Each xS In xR
        If Not Intersect(Target, Range(xS)) Is Nothing Then
            '§Aªº³B²zµ{§Ç
            MsgBox xS
            Exit Sub
        End If
    Next
End Sub
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦¨´N¤@¤Á¡j®É¶¡¥i¥H³y´N¤H®æ¡A¥i¥H¦¨´N¨Æ·~¡A¤]¥i¥HÀx¿n¥\¼w¡C
ªð¦^¦Cªí ¤W¤@¥DÃD