ªð¦^¦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 : ¦³¤ß´N¦³ºÖ¡A¦³Ä@´N¦³¤O¡A¦Û³yºÖ¥Ð¡A¦Û±oºÖ½t¡C
ªð¦^¦Cªí ¤W¤@¥DÃD