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

[µo°Ý] ½Ð°ÝVBA ªºµ{¦¡¦³¨S¦³¥i¥H¿ë»{¬Y­ÓÀx¦s®æ¤ºªº¦r¤¸¦³µL¥]§t¬Y´X­Ó¦r¦ê¡H

¦^´_  GBKEE


With Sheet1                        (³o¥y¬O§_§ïWith State sheet?)
With Sheet2      ...
198188 µoªí©ó 2013-3-9 23:00



    With Sheet1                        (³o¥y¬O§_§ïWith State sheet?)  ³oºØ¼gªkÀ³¸Ó·|¥X²{¿ù»~
°£«D¦³¥t¥~«Å§i

  ¦h°µ¦h·Q¦h¾Ç²ß¡A¤Ö¬Ý¤Ö¿ù¤Ö°g³~

  ¦h°µ=¦h¦h½m²ß¡A¦h¦h½s¼g¡C
  ¦h·Q=·Q·Q¬°¤°»ò¤H®aµ{¦¡­n¨º¼Ë¼g¡A¦pªG´«¦¨¦Û¤v¡A¤S·|«ç¼g¡C
  ¦h¾Ç²ß=¾Ç²ß¤H®aªºµo°Ý¨Ã¸Ñµª¡A¾Ç²ß¤H®aªº¼gªk

  ¤Ö¬Ý=¥u¬Ý¤£°µ¤]ªPµM

TOP

¦^´_ 28# GBKEE

If Worksheets("OHC").Range("G" & i) - Date <= 2 Then
    Worksheets("OHC").Range("G" & i).Interior.Color = RGB(255, 251, 45)
    Worksheets("OHC").Range("G" & i).Font.ColorIndex = RGB(217, 24, 9)
    End If

½Ð°Ý¤j¤j¡AIf Worksheets("OHC").Range("G" & i) - Date <= 2 Then ³o¥y­þ¸Ì¥X²{°ÝÃD¤F¡H

TOP

¦^´_  GBKEE

If Worksheets("OHC").Range("G" & i) - Date
198188 µoªí©ó 2013-3-13 11:31



    If Worksheets("OHC").Range("G" & i) - Date   
  §â¨â¬q¤À¶}
If Worksheets("OHC").Range("G" & i)
-
Date

  ¦h°µ¦h·Q¦h¾Ç²ß¡A¤Ö¬Ý¤Ö¿ù¤Ö°g³~

  ¦h°µ=¦h¦h½m²ß¡A¦h¦h½s¼g¡C
  ¦h·Q=·Q·Q¬°¤°»ò¤H®aµ{¦¡­n¨º¼Ë¼g¡A¦pªG´«¦¨¦Û¤v¡A¤S·|«ç¼g¡C
  ¦h¾Ç²ß=¾Ç²ß¤H®aªºµo°Ý¨Ã¸Ñµª¡A¾Ç²ß¤H®aªº¼gªk

  ¤Ö¬Ý=¥u¬Ý¤£°µ¤]ªPµM

TOP

¦^´_ 32# 198188
If Worksheets("OHC").Range("G" & i) - Date <= 2 Then ³o¥y­þ¸Ì¥X²{°ÝÃD¤F¡H
±ø¥ó¦¡:  Range("G?")(<- ¥²»Ý¬O¤é´Á) - Date(·í¤Ñ¤é´Á)<=2(¤Ñ)
§A»¡¥X²{°ÝÃD¤F ,½Ð»¡©ú¥Õ!!
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¦^´_ 34# GBKEE


    ¨â­Ó³£¬O¤é´Á¡A¦ý¬O¹q¸£»¡typing mistake, ©Ò¥H§Ú·Q°Ý¬O¤£¬O§Úªº»yªk¦³¿ù¡H

TOP

¦^´_ 35# 198188
typing mistake ªºÂ½Ä¶¬O¿é¤J¿ù»~
½ÐÀˬd Range("g?")¬O§_¬O¼Æ¦r,©Î¶Ç¤WÀɮ׬ݬÝ
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¦^´_ 32# 198188


    À³¸Ó³o¥y¿ù»~
Worksheets("OHC").Range("G" & i).Font.ColorIndex = RGB(217, 24, 9)
ColorIndex À³¸Ó¬O¼Æ­È¤£¥i¨Ï¥ÎRGB
¥i§ï¦¨
Worksheets("OHC").Range("G" & i).Font.Color = RGB(217, 24, 9)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

like ·|¤ñ¸û¦n¥Î¡C
­É¿ú¤£ÁÙ¡A¤~¬O¤ý¹D

TOP

        ÀR«ä¦Û¦b : ÀR§¤±`®¦¤v¹L¡B¶¢½Í²ö½×¤H«D¡C
ªð¦^¦Cªí ¤W¤@¥DÃD