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

Àx¦s®æ¤ñ¹ï«á.¾É¤J·Æ¹«¦ì¸m°ÝÃD2

¦^´_ 10# BV7BW

.Item(1).Select
.Item(1).Font.Color = vbRed  '¥[³o¤@¦æ

¥t¦³°ÝÃD, »P¥»ÃDµL¬ÛÃö®É, ¥i¥t¶}©«~~¤£¤@©w¦³ªÅÀ°¦£...²´·ú¤w§Ö¸C¤£¶}¤F

TOP

¦^´_ 11# ­ã´£³¡ªL

·PÁ ­ã´£³¡ªL ¦Ñ®v
±Ó¦Ó¦n¾Ç,¤£®¢¤U°Ý

TOP

¦^´_ 10# BV7BW


    ¸É¥R ÂùÀ»¸ò³æÀ» ³£¥i¥H¦Û¤v¨M©w§ó§ï
    T1Àx¦s®æ¥i¥H§ïÅܧAªº»Ý¨D

Àx¦s®æ¦ì¸m¾É¤J v2.zip (78.49 KB)

TOP

¦^´_ 13# singo1232001
·PÁ singo1232001 ¤j¤j «ü¾É

ÁÂÁ§A.ÂùÀ».³æÀ»³£«Ü¶¶ºZ¹BÂà.¦n¹³¦³´M§ä¸ê®Æ¹BÂà®É¶¡§Ö

¦A¦¸·PÁ singo1232001 ¤j¤j ÁÂÁ§A
±Ó¦Ó¦n¾Ç,¤£®¢¤U°Ý

TOP

¦^´_ 9# ­ã´£³¡ªL

­ã´£³¡ªL ¦Ñ®v §A¦n

XL10000045-1¤¤
"hÄæ"¤½¦¡.¬O§_¥iª½±µ±a¤J¤U¤@Äæ

¥Ø«e¬O¥H¤U©Ô¤è¦¡¸É¨¬.¤]´N¬O¨Cµ§¼W¦C¸ê®Æ«á´N¶·¤U©Ô1¦¸
¤]¥i¸ò"mÄæ"§@ªk¬Û¦P
   ÁÂÁÂ
±Ó¦Ó¦n¾Ç,¤£®¢¤U°Ý

TOP

¦^´_ 15# BV7BW

Âù«öP1
If .Row = 1 Then
        With Range("e1:n" & R)
             .Borders.LineStyle = 1
             .Columns(9) = .Columns(9).Value
        End With
        Range("h1:h" & R).Formula = "=IF(ROW(A1)=1,""(KG)"",IF(F1=""¥x¤ç"",(MOD(E1,1)*100/16+INT(E1)),E1)*G1)" '¥[³o¤@¦æ

TOP

¦^´_ 16# ­ã´£³¡ªL
ÁÂÁ ­ã³ö³¡ªL ¦Ñ®v
¤w¥i¹B§@.
ÁÂÁÂ
±Ó¦Ó¦n¾Ç,¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ singo1232001 ©ó 2021-6-25 13:43 ½s¿è

¦^´_ 17# BV7BW


    ³o­ÓÆZ¦nª±ªº  À°§Ú¬ð¯}¤F¤@­Ó¼gªk ¤]Âç²M¤F¤@¨Ç«ä¸ô

    ³o­Ó¼gªk§Ú²Ä¤@¦¸¼g §Ú²q¸Ì­±¥i¯à·|¦³bug ¦ý¥Ø«eÁÙ¤£½T©w

    ¥Ø«eªº¯ÊÂI¬OµLªk´_­ì

Àx¦s®æ¦ì¸m¾É¤J v3.zip (84.05 KB)

TOP

¦^´_ 18# singo1232001
·PÁÂ singo1232001 ¤j¤j

´£¨Ñ2ª©¥»³£¥i¹B§@±¡ªp¨Ñ°Ñ¦Ò
§Æ±æ¦³§U singo1232001 ¤j¤j «ä¸ô¬ð¶i
¨¾§b_«È¤á1.zip (55.9 KB)
±Ó¦Ó¦n¾Ç,¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¤ß¤¤±`¦sµ½¸Ñ¡B¥]®e¡B·P«ä¡Bª¾¨¬¡B±¤ºÖ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD