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

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

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

¦b¦P¤u§@¤¤¦³3­Ó¦WºÙªº³]©w¡A¨Ò¦p¬OABC¡BDEF¡BGHI¡A¨ärange ¤À§O¬O$A$1¡G$G$30¡B    $A$31¡G$G$45¡B   $A$46¡G$G$78
¦³¨S¦³¤èªk¯à¦b«ö¤@¤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

¦^´_ 2# ML089
±z¯u§Q®`¡A¤Ó·PÁ¤F¡I
¾Ç¨ì¤F¤@©Û

TOP

        ÀR«ä¦Û¦b : ¹ï¤÷¥À­nª¾®¦¡A·P®¦¡B³ø®¦¡C
ªð¦^¦Cªí ¤W¤@¥DÃD