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

©I¥s¦Û­q¨ç¼Æ

©I¥s¦Û­q¨ç¼Æ

§Ú¦³¤@­Óµ{¦¡½X¡A¦p¤U
½Ð°Ý§Ú­n¦p¦ó©I¥s¦Û­q¨ç¼Æ
§Ú¿ï¤½¦¡¡Ö´¡¤J¨ç¼Æ¡A§ä¤£¨ì¨Ï¥ÎªÌ©w¸q¨ç¼Æ¡A­n½Ð±Ð¦p¦ó©I¥s¦Û­q¨ç¼Æ¡A
¥i§_¼g¨BÆJ¥X¨Ó¡A·PÁÂ

Function AUTO_CATEGORY(A, B, C)
   
    Dim result_start, result_make, result1, result2, result3, result4, result5
   
    Dim result6, result7, result8, result9, result10, result11
   
    Dim result12, result13, result14, result15, result16, result17
   
    Dim result18, result19, result20, result21, result22, result23, result24
   
    Dim result25, result26, result27, result28, result29, result30, result31
   
    Dim result32, result33, result34, result35, result36, result37, result38
   
    Dim result39, result40, result41, result42, result43, result44, result45, result46
   
    result_make = InStr(A.Value, "7070")
    result_start = InStr(B.Value, "7070")
    result1 = InStr(C.Value, "¶g¥X±b")
    result2 = InStr(C.Value, "¡]¢°¡^")
    result3 = InStr(C.Value, "°O¤íµo²¼µ|ÃBÂà¦C")
    result4 = InStr(C.Value, "«D°O¤í")
    result5 = InStr(C.Value, "¡]¢³¡^")
    result6 = InStr(C.Value, "¡]¢´¡^")
    result7 = InStr(C.Value, "»¼©µ±b¶µÅu´£")
    result8 = InStr(C.Value, "À³¦¬")
    result9_1 = InStr(C.Value, "¾Ç¥Í±JªÙ")
    result9_2 = InStr(C.Value, "±JªÙ")
    result9_3 = InStr(C.Value, "±Jºô")
    result10 = InStr(C.Value, "WI-FI")
    result11 = InStr(C.Value, "¹w¦¬ÂàÀ禬")
    result12 = InStr(C.Value, "¹º")
    result13 = InStr(C.Value, "¶V")
    result14 = InStr(C.Value, "À³Åu")
    result15 = InStr(C.Value, "À禬±b¶µ½Õ¾ã")
    result16 = InStr(C.Value, "¡]¢¶¡^")
    result16_1 = InStr(C.Value, "¼Æ¾Úµo²¼ÃþªA°ÈÂà¦CÀ禬")
    result17 = InStr(C.Value, "±b³æ¦X¨ÖÀ禬½Õ¾ã")
    result18 = InStr(C.Value, "½Õ§ï±b¶Ç²¼")
    result19 = InStr(C.Value, "µ¡¤f")
    result20 = InStr(C.Value, "°h")
    result21 = InStr(C.Value, "§ó¥¿")
    result22 = InStr(C.Value, "À禬Âà±b¨Æ¶µ")
    result23 = InStr(C.Value, "À禬¾P±b¹º¥X¶Ç²¼")
    result24 = InStr(C.Value, "¬ì¥Ø½Õ¾ã")
    result25 = InStr(C.Value, "«Ø°Ó")
    result26 = InStr(C.Value, "±b°È½Õ±b")
    result27 = InStr(C.Value, "LB410")
    result28 = InStr(C.Value, "¤H¤u±b")
    result29 = InStr(C.Value, "¹w¦ô")
    result30 = InStr(C.Value, "µo²¼Ãþ­t¼Æ")
    result31 = InStr(C.Value, "½Õ§ï±b¤J±b")
    result32 = InStr(C.Value, "¸É¾P±b")
    result33 = InStr(C.Value, "¼Æ¾Úµo²¼·~°È­t¼Æ")
    result34 = InStr(C.Value, "¬ì¥Ø»~¦CÂॿ")
    result35 = InStr(C.Value, "§Kµ|")
    result36 = InStr(C.Value, "·|­p¬ì¥ØÂॿ")
    result37 = InStr(C.Value, "¨R±b")
    result38 = InStr(C.Value, "¬õ§Q")
    result39 = InStr(C.Value, "¶g¦ô¦C")
    result40 = InStr(C.Value, "¶gµo²¼Ãþ¤ë¯²¶O")
    result41 = InStr(C.Value, "¥¼¾P±b")
    result42 = InStr(C.Value, "À³¦¬­x¨Æ")
    result43 = InStr(C.Value, "¬O¤è")
    result44 = InStr(C.Value, "µ²ºâ")
    result45 = InStr(C.Value, "¤½¸Ü")
    result46 = InStr(C.Value, "¥~Àð")
    result47 = InStr(C.Value, "HINET¹wú¨îµo²¼¤Îµo²¼§@·~«e¹wú¬ì¥ØÂà¦C")
    result48 = InStr(C.Value, "¬ì¥ØÂà¦C")
    result49 = InStr(C.Value, "À禬±b¶µ½Õ¾ã")
    result50 = InStr(C.Value, "¥X¯²©ãª÷³]ºâ§Q®§")
   
    If (result1 > 0 And result_start = 0) Then
        AUTO_CATEGORY = "¨t²Î¥X±b"
    ElseIf (result2 <> 1 And result3 > 0) Then
        AUTO_CATEGORY = "°O¤íµo²¼"
    ElseIf (result > 0 And result_start > 0) Then
        AUTO_CATEGORY = "HD°O¤í"
    ElseIf (result2 = 1 And result3 > 0) Then
        AUTO_CATEGORY = "HD°O¤í"
    ElseIf (result2 = 1 And result4 > 0) Then
        AUTO_CATEGORY = "HD«D°O¤í"
    ElseIf (result5 = 1) Then
        AUTO_CATEGORY = "¦¬¤ä¨t²Î"
    ElseIf (result6 = 1 Or result7 > 0 Or result8 = 1) Then
        AUTO_CATEGORY = "¦¬¤ä½Õ¾ã"
    ElseIf (result9_1 > 0 Or result9_2 > 0 Or result9_3 > 0) Then
        AUTO_CATEGORY = "¦¬¤ä½Õ¾ã"
    ElseIf (result10 > 0 Or result11 > 0) Then
        AUTO_CATEGORY = "¦¬¤ä½Õ¾ã"
    ElseIf (result_make = 0 And result12 = 1 And result13 = 0) Then
        AUTO_CATEGORY = "¦¬¤ä½Õ¾ã"
    ElseIf (result_make > 0 And result12 > 0 And result13 = 0) Then
        AUTO_CATEGORY = "À³¥IÅu¤À"
    ElseIf (result_make > 0 And result14 > 0) Then
        AUTO_CATEGORY = "À³¥IÅu¤À"
    ElseIf (result_make > 0 And result15 > 0) Then
        AUTO_CATEGORY = "À³¥IÅu¤À"
    ElseIf (result16 = 1 Or result16_1 > 0) Then
        AUTO_CATEGORY = "¹w¦¬ÂàÀ禬"
    ElseIf (result17 > 0 Or result18 > 0 Or result20 > 0 Or result21 > 0) Then
        AUTO_CATEGORY = "½Õ§ï±b"
    ElseIf (result5 <> 1 And result19 > 0) Then
        AUTO_CATEGORY = "½Õ§ï±b"
    ElseIf (result22 > 0 Or result23 > 0 Or result24 > 0 Or result25 > 0) Then
        AUTO_CATEGORY = "½Õ§ï±b"
    ElseIf (result26 > 0 Or result27 > 0 Or result30 > 0 Or result31 > 0) Then
        AUTO_CATEGORY = "½Õ§ï±b"
    ElseIf (result28 > 0 And result29 = 0) Then
        AUTO_CATEGORY = "½Õ§ï±b"
    ElseIf (result32 > 0 Or result33 > 0 Or result34 > 0 Or result35 > 0) Then
        AUTO_CATEGORY = "½Õ§ï±b"
    ElseIf (result36 > 0 Or result37 > 0 Or result47 > 0 Or result48 > 0 Or result49 > 0) Then
        AUTO_CATEGORY = "½Õ§ï±b"
    ElseIf (result_make > 0 And result29 > 0 And result38 = 0) Then
        AUTO_CATEGORY = "¼Æ¤À¦ô¦C"
    ElseIf (result39 > 0 Or result40 > 0) Then
        AUTO_CATEGORY = "¥_¤À¦ô¦C"
    ElseIf (result41 > 0) Then
        AUTO_CATEGORY = "¥¼¾P±b¦ô¦C"
    ElseIf (result42 > 0 Or result43 > 0 Or result44 = 1 Or result45 > 0 Or result46 > 0 Or result50 > 0) Then
        AUTO_CATEGORY = "¨ä¥L"
    ElseIf (result38 > 0) Then
        AUTO_CATEGORY = "¬õ§Q¿nÂI"
    Else
        AUTO_CATEGORY = "[No Match Rule?]"
    End If
   
End Function
joyce

¼g¦b Module ¤¤ªº public function ³£¥i¥H¦b¨ç¼Æªº¨Ï¥ÎªÌ©w¸q¤¤§ä¨ì

ª½±µ¦b cell ¤¤¿é¤J¤]¥i¥H

TOP

¦^´_ 2# diolin


     ¤£¦n·N«ä¡A¹ïvba«Ü­¯¥Í¡A
¡@·Q½Ð°Ý¦bfunction«e­±¥[public¡A³o¬O«ü¤°»ò·N«ä¡C¡C¡C

ÁÂÁ«ü¾É
joyce

TOP

¨ä¹ê¤£¥[ public , ¹w³]¤]¬O public

´N¬O¥i¥Hµ¹ Module ¥~ªº©I¥s

¦pªG¬O private , ´N¥u¦³¸Ó Module ¸Ì¥i¥H©I¥s

TOP

        ÀR«ä¦Û¦b : ¯u¥¿ªº·R¤ß¡A¬O·ÓÅU¦n¦Û¤vªº³oÁû¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD