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

[µo°Ý] ½Ð°Ý,¦p¦ó«ü©w­n°õ¦æªº¥¨¶°

[µo°Ý] ½Ð°Ý,¦p¦ó«ü©w­n°õ¦æªº¥¨¶°

½Ð°Ý¦U¦ì¤j¤j!!
­n¦p¦ó«ü©w­n°õ¦æªº¥¨¶°
¨Ò¦p:  A1¦³¸ê®Æ«h°õ¦æA¥¨¶°
          A5¦³¸ê®Æ«h°õ¦æC¥¨¶°
          A7¦³¸ê®Æ«h°õ¦æD¥¨¶°

ÁÂÁ¨â¦ì¤j¤jªº¦^ÂÐ!!!!!

TOP

Sub AA()
X = Sheet1.Range("A1")
Y = Sheet1.Range("A5")
Z = Sheet1.Range("A7")
If X <> "" Then
Application.Run "A"
End If
If Y <> "" Then
Application.Run "C"
End If
If Z <> "" Then
Application.Run "D"
End If
End Sub
ù

TOP

¥»©«³Ì«á¥Ñ luhpro ©ó 2014-9-18 00:10 ½s¿è
½Ð°Ý¦U¦ì¤j¤j!!
­n¦p¦ó«ü©w­n°õ¦æªº¥¨¶°
¨Ò¦p:  A1¦³¸ê®Æ«h°õ¦æA¥¨¶°
          A5¦³¸ê®Æ«h°õ¦æC¥¨¶°
  ...
gctsai µoªí©ó 2014-9-17 23:16

§A·Q­nªº¬O³o¼Ëªº¶Ü?
  1.   If [A1] <> "" Then A
  2.   If [A5] <> "" Then C
  3.   If [A7] <> "" Then D
½Æ»s¥N½X
©Î¬O©³¤U³oºØ?
  1.   If [A1] <> "" Then Run "A"
  2.   If [A5] <> "" Then Run "C"
  3.   If [A7] <> "" Then Run "D"
½Æ»s¥N½X

TOP

        ÀR«ä¦Û¦b : ¤Hªº¤ß¦a¬O¤@²¥¥Ð¡A¤g¦a¨S¦³¼½¤U¦nºØ¤l¡A¤]ªø¤£¥X¦nªºªG¹ê¡C -
ªð¦^¦Cªí ¤W¤@¥DÃD