ªð¦^¦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 : ¡i¬O§_µo´§¤F¨}¯à¡H¡j¤H¶¡¹Ø©R¦]¬°µu¼È¡A¤~§óÅã±o¬Ã¶Q¡CÃø±o¨Ó¤@½ë¤H¶¡¡AÀ³°Ý¬O§_¬°¤H¶¡µo´§¤F¦Û¤vªº¨}¯à¡A¦Ó¤£­n¤@¨ý¨Dªø¹Ø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD