[¤w¸Ñ¨M][µo°Ý]µ{¦¡Â²¤Æ-°}¦C-VBA ¡A´M§ä¬Y¤¸¯À¬O§_¦s¦b°}¦C¤¤¡C
- ©«¤l
- 132
- ¥DÃD
- 25
- ºëµØ
- 0
- ¿n¤À
- 199
- ÂI¦W
- 0
- §@·~¨t²Î
- window XP
- ³nÅ骩¥»
- Excel 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW ·s¦Ë
- µù¥U®É¶¡
- 2010-6-1
- ³Ì«áµn¿ý
- 2022-7-14
|
[¤w¸Ñ¨M][µo°Ý]µ{¦¡Â²¤Æ-°}¦C-VBA ¡A´M§ä¬Y¤¸¯À¬O§_¦s¦b°}¦C¤¤¡C
¥»©«³Ì«á¥Ñ Baracuda ©ó 2011-4-7 09:24 ½s¿è
- Option Explicit
- Option Base 1
- Dim Input_No As Integer, Output_No As Integer
- Dim Output_Sht_Name_Ary, Input_Sht_Name_Ary
- Sub initial()
- Input_Sht_Name_Ary = Array("¤@", "¤", "¤K")
- Output_Sht_Name_Ary = Array("¤@", "¤G", "¤T", "¥|", "¤", "¤»")
- Input_No = UBound(Input_Sht_Name_Ary)
- Output_No = UBound(Output_Sht_Name_Ary)
- End Sub
- Sub main()
- Call initial
- Call Print_Not_Found
- End Sub
- Sub Print_Not_Found()
- Dim Sht_Cnt As Integer
- Dim Ctr_1 As Integer, Ctr_2 As Integer
- Dim Found_Or_Not As Boolean
-
- Found_Or_Not = False
-
- For Ctr_1 = 1 To Input_No
-
- For Ctr_2 = 1 To Output_No
- If Input_Sht_Name_Ary(Ctr_1) = Output_Sht_Name_Ary(Ctr_2) Then
- Found_Or_Not = True
- Exit For
- End If
- Next Ctr_2
- If Not (Found_Or_Not) Then
- Debug.Print Input_Sht_Name_Ary(Ctr_1)
- End If
-
- Found_Or_Not = False
- Next Ctr_1
- End Sub
½Æ»s¥N½X |
|
|
|
|
|
|
- ©«¤l
- 132
- ¥DÃD
- 25
- ºëµØ
- 0
- ¿n¤À
- 199
- ÂI¦W
- 0
- §@·~¨t²Î
- window XP
- ³nÅ骩¥»
- Excel 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW ·s¦Ë
- µù¥U®É¶¡
- 2010-6-1
- ³Ì«áµn¿ý
- 2022-7-14
|
µ{¦¡ªºì©l½X¦p¤W¡G
²{¦b¬O¥Î2 Ó廻°é¦b´M§ä¬O§_ Input ªº Element ¦³¦s¦b Output ªº Array ¤¤¡C
·Q½Ð°Ý¦³µL¸û²¼äªº»yªk¥i¥H¸Ñ¨M¡C
¨Ì·Ó²{¦bªºµ{¦¡¥i¥H§ä¥X "¤K"¬O¤£¦b Array Output ¤§¤¤¡C |
|
|
|
|
|
|
- ©«¤l
- 227
- ¥DÃD
- 3
- ºëµØ
- 1
- ¿n¤À
- 273
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- XP
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2011-3-22
- ³Ì«áµn¿ý
- 2013-1-29
|
a = Array("¤@", "¤", "¤K")
b = Array("¤@", "¤G", "¤T", "¥|", "¤", "¤»")
For i = 0 To UBound(a)
If UBound(Filter(b, a(i))) = -1 Then
MsgBox "¤£ ¥]§t" & a(i)
Else
MsgBox "¥]§t" & a(i)
End If
Next |
|
|
|
|
|
|
- ©«¤l
- 132
- ¥DÃD
- 25
- ºëµØ
- 0
- ¿n¤À
- 199
- ÂI¦W
- 0
- §@·~¨t²Î
- window XP
- ³nÅ骩¥»
- Excel 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW ·s¦Ë
- µù¥U®É¶¡
- 2010-6-1
- ³Ì«áµn¿ý
- 2022-7-14
|
chin15 ªº¤èªk¤ñ§Úªº¦³®Ä²v¡C
¤Ö¤F¤@Ó Loop ¡C
³o¼Ëªºµ{¦¡¤]¤ñ¸û²µu¡C
¦pªGÁÙ¦³§Oªº¤è¦¡¡A½Ð¦U¦ì¤jô¤j©j¦AÀ°¦£¤@¤U¡C |
|
|
|
|
|
|
- ©«¤l
- 5923
- ¥DÃD
- 13
- ºëµØ
- 1
- ¿n¤À
- 5986
- ÂI¦W
- 0
- §@·~¨t²Î
- win10
- ³nÅ骩¥»
- Office 2010
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW°ò¶©
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2022-1-23
|
¥»©«³Ì«á¥Ñ GBKEE ©ó 2011-3-29 10:26 ½s¿è
¦^´_ 4# Baracuda - Sub Ex()
- A = Array("¤@", "¤", "¤K")
- b = Array("¤@", "¤G", "¤T", "¥|", "¤", "¤»")
- For Each E In A
- M = Application.Match(E, b, 0)
- MsgBox E & IIf(IsNumeric(M), "¦s¦b©ó ", " ¤£¦s¦b©ó ") & Join(b, ",")
- Next
- End Sub
½Æ»s¥N½X |
|
|
|
|
|
|
- ©«¤l
- 132
- ¥DÃD
- 25
- ºëµØ
- 0
- ¿n¤À
- 199
- ÂI¦W
- 0
- §@·~¨t²Î
- window XP
- ³nÅ骩¥»
- Excel 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW ·s¦Ë
- µù¥U®É¶¡
- 2010-6-1
- ³Ì«áµn¿ý
- 2022-7-14
|
GBKEE ÁÂÁ¡C
³oÓµ{¦¡ Work
½Ð°Ý¤@¤UÅܼƪº«¬ºA
E & M ¦U¬°¦óºØ«¬ºA¡C§Ú²{¦b¬O³]¦¨ Variant
E ³]¦¨ String ¤£·|work¡C
½Ð½ç±Ð¤@¤U¡C |
|
|
|
|
|
|
- ©«¤l
- 227
- ¥DÃD
- 3
- ºëµØ
- 1
- ¿n¤À
- 273
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- XP
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2011-3-22
- ³Ì«áµn¿ý
- 2013-1-29
|
¥i¥H¥ÎTypeName ¨ç¼Æ¨ú±oÅܼÆÃþ«¬
MsgBox TypeName(M) |
|
|
|
|
|
|
- ©«¤l
- 132
- ¥DÃD
- 25
- ºëµØ
- 0
- ¿n¤À
- 199
- ÂI¦W
- 0
- §@·~¨t²Î
- window XP
- ³nÅ骩¥»
- Excel 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW ·s¦Ë
- µù¥U®É¶¡
- 2010-6-1
- ³Ì«áµn¿ý
- 2022-7-14
|
ÁÂÁ GBKEE¡A§Ú¤]¬O¥ý³o¼Ë³]©wÅܼƫ¬ºA¡C
¥u¬O§Ú©È¤Ó¹L©ó¯Ó¨t²Î¸ê·½(ÁöµM²{¦bªº¨t²Î¸ê·½³£ÁÙ¦n)¡A¦ý¬O¬°¾i¦¨¦n²ßºD¡AÁÙ¬O¥±`´N¬ÙµÛÂI¥Î¡C |
|
|
|
|
|
|