ªð¦^¦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¥Í©R¦b©I§l¶¡¡j¦òªû»¡¡G¡u¥Í©R¦b©I§l¶¡¡C¡v¤HµLªkºÞ¦í¦Û¤vªº¥Í©R¡A§óµLªk¾×¦í¦º´Á¡AÅý¦Û¤v¥Ã¦í¤H¶¡¡C¬JµM¥Í©R¥h¨Ó³o»òµL±`¡A§Ú­Ì§óÀ³¸Ó¦n¦n¦a·R±¤¥¦¡B§Q¥Î¥¦¡B¥R¹ê¥¦¡AÅý³oµL±`¡BÄ_¶Qªº¥Í©R¡A´²µo¥¦¯uµ½¬üªº¥ú½÷¡A¬M·Ó¥X¥Í©R¯u¥¿ªº»ù­È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD