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

¥i¥H±NÀx¦s®æªº¤º®eÅܦ¨VBAªºµ{¦¡½X¶Ü?

¥i¥H±NÀx¦s®æªº¤º®eÅܦ¨VBAªºµ{¦¡½X¶Ü?

¥»©«³Ì«á¥Ñ woteil ©ó 2013-2-10 01:36 ½s¿è

Sub Test()
        IF CELLS(X,Y)>CELLS(I,J) THEN  ......'do something
End Sub

A1=CELLS(X,Y)>CELLS(I,J)

´N¬O¦bSub Test¤¤¬õ¦âªº±ø¥ó,¥i¥H±qA1Àx¦s¤¤°ÊºA§ì¨ú¶Ü?

Sub Test()
        IF CELLS(X,Y)>30 THEN  ......'do something
End Sub

A1=CELLS(X,Y)>30
woteil

cells(x,y) = "=¤½¦¡"& c
c ¬OÅܼÆ
Timothy

TOP

¨Ï¥ÎScriptControl¥i¥H¹ê²{¨ú­È¡C

TOP

¦^´_ 1# woteil
±z应该¬O这个·N«ä§a
A1¤¤¥i¥H写¥ô·N逻辑ªí达¦¡
  1. Sub Test()
  2.    If [A1] Then
  3.       'Do Sth. here
  4.    End If
  5. End Sub
½Æ»s¥N½X
¦V°ª¤â学习

TOP

        ÀR«ä¦Û¦b : ¯¸¦b¥b¸ô¡A¤ñ¨«¨ì¥Ø¼Ð§ó¨¯­W¡C
ªð¦^¦Cªí ¤W¤@¥DÃD