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

[µo°Ý] IF...THEN¤@°Ý

[µo°Ý] IF...THEN¤@°Ý

Private Sub Worksheet_Change(ByVal Target As Range)
'If Cell(D2)¤º¼Æ­È¥X²{§ïÅÜ,Then    <<<½Ð±Ð¤j¤j¡A³o¥yÀ³¦p¦ó¼g¡AÁÂÁÂ!
Call myPrg
End Sub

³o¼Ë¹ï¶Ü?
Private Sub Worksheet_Change(ByVal Target As Range)
Dim rng As Range

    Set rng = Worksheets("Sheet1").[D2]

    If Not Intersect(Target, rng) Is Nothing Then

Call myPrg
End If
End Sub

TOP

¦^´_ 3# GBKEE

ÁÂÁª©¤j«ü¾É!

TOP

        ÀR«ä¦Û¦b : °ß¨ä´L­«¦Û¤vªº¤H¡A¤~§ó«i©óÁY¤p¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD