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

[¤À¨É] Visual Basic ¨ç¼Æ

[¤À¨É] Visual Basic ¨ç¼Æ

¥»©«³Ì«á¥Ñ Min ©ó 2010-5-13 06:48 ½s¿è
  1. VB¨ç¼Æ»¡©ú / VB¨ç¼Æ¥Îªk

  2. µ´¹ï­È / Abs(number)

  3. ¶Ç¦^°}¦C½d¥» / Array(arglist)

  4. ºâ¦r¤¸ªºASCII½X / Asc( string)

  5. ÂàBoolean«¬ºA­È / CBool( expression )

  6. ÂàByte«¬ºA­È / CByte( expression )

  7. ÂàCurrency«¬ºA­È / CCur (expression )

  8. ÂàDate«¬ºAªº­È / CDate (date )

  9. Âà Double «¬ºAªº­È / CDbl (expression )

  10. ÂàASCII½Xªí¥Üªº¦r¤¸ / Chr (charcode)

  11. Âର¾ã¼Æ«¬ºA / CInt(expression)

  12. Âରªø¾ã¼Æ«¬ºA / Clng (expression )

  13. ¶Ç¦^ª«¥ó½d¥» / CreateObject (class)

  14. Âର³æºë«×«¬ºA / CSng (expression)

  15. Âର¦r¦ê«¬ºA / CStr (expression )

  16. ¶Ç¦^¥Ø«e¨t²Î®É¶¡ / Date

  17. ¶Ç¦^§ó§ïªº®É¶¡ / DateAdd (interval, number, date)

  18. ¶Ç¦^¨â¤é´Áªº¶¡¹j / DateDiff (interval,date1,date2)

  19. ¶Ç¦^¬Y®É¶¡ªº³¡¤À­È / DatePart (interval,date)

  20. Âà´«¬Y®É¶¡Date«¬ºA / DateSerial(year, month, day)

  21. ¶Ç¦^°}¦C¤ºªº¦r¦ê¦ì¸m / Filter (InputStrings, Value)

  22. ¶Ç¦^Date «¬ºAªº­È / DateValue(date)

  23. ¶Ç¦^1~31ªº¤é´Á¼Æ¦r / Day(date)

  24. ³Ì¤j¾ã¼Æ­È / Int (number )

  25. µL±ø¥ó±Ë¥h¤p¼Æ / Fix (number)

  26. ¶Ç¦^ªí¥Ü¦¡«¬¦¡ / FormatCurrency(Expression)

  27. ¶Ç¦^¤é´Á©Î®É¶¡ªí¥Ü¦¡ / FormatDateTime (Date)

  28. ¶Ç¦^¼Æ¦rªºªí¥Ü¦¡ / FormatNumber(Expressiom)

  29. ¶Ç¦^¦Ê¤À¤ñªºªí¥Ü¦¡ / FormatPercent(Expression)

  30. ¨ú¦^Àɮפºªºª«¥ó / GetObject([pathname][,class])

  31. Âର16¶i¦ì / Hex(number)

  32. ¶Ç¦^®É¶¡ªº®É¼Æ / Hour(time)

  33. Åã¥Ü¥i¨Ñ¿é¤Jªº¹ï¸Üµ¡ / inputBox(prompt,......)

  34. ¶Ç¦^·j´M¦r¦êªº¦ì¸m / InStr(string,searchstr)

  35. ±q§ÀºÝ·j´M¦r¦ê¦ì¸m / InstrRev(string,searchstr)

  36. §P©wÅܼƬO§_¬°°}¦C / IsArray(varname)

  37. §P©w¬O§_¬°¤é´Áªí¥Ü¦¡ / IsDate(expression)

  38. §P©wÅܼƤº¬O§_¦³¤º®e / IsEmpty(expression)

  39. §P©w¬O§_¬°NULL­È / IsNull(expression)

  40. §P©w¬O§_¬°¼Æ¦r­È / IsNumeric(expression)

  41. ¶Ç¦^¤@­Ó¹Ï¤ùª«¥ó / LoadPicture(picturename)

  42. §P©w¬O§_¬°¤@­ÓÅÜ¼Æ / IsObject(expression)

  43. ¦r¦ê¥[¤J°}¦C¤º / Join(list[,delimiter])

  44. Âର¤p¼g¦r¦ê / LCase(string)

  45. ¦r¦ê¨ú¥ªÃäªø«× / Left(string,ength)

  46. ¶Ç¦^¦r¦êªø«× / Len(string|varname)

  47. ¶Ç¦^¦ÛµM¹ï¼Æ­È / Log(number)

  48. ¥h°£¦r¦êªº¥ªÃäªÅ¥Õ / LTrim(string)

  49. ¥h°£¦r¦êªº¥kÃäªÅ¥Õ / RTrim(string)

  50. ¥h°£¦r¦êªº¥ª¥kÃäªÅ¥Õ / Trim(string)

  51. ¶Ç¦^«ü©w¦ì¸mªº¦r¦ê / Mid(string,start[,length])

  52. ¶Ç¦^®É¶¡ªº¤ÀÄÁ / Minute(time)

  53. ¶Ç¦^¤é´Áªº¤ë¥÷ / Month(date)

  54. ¶Ç¦^¤ë¥÷¦r¦ê / MonthName(month[,abbreviate)

  55. Åã¥Ü¤@­Ó°T®§µ¡ / MsgBox(prompt,...)

  56. ¶Ç¦^¨t²Î¤é´Á»P®É¶¡/ Now

  57. Âର¤K¶i¦ì¼Æ¦r / Oct(number)

  58. ¨ú¥N³¡¥÷¦r¦ê / Replace(string,find,replacewith)

  59. ¦r¦ê¨ú¥kÃäªø«× / Right(string,ength)

  60. ¶Ç¦^¤@­ÓÀH¾÷¼Æ¦r / Rnd[(number)]

  61. «ü©w¦r¦êÂন°}¦C / Split(expression,...)

  62. ¶Ç¦^¨Ï¥ÎªºScript»y¨¥ / ScriptEngine

  63. ¶Ç¦^®É¶¡ªº¬í¼Æ / Second(time)

  64. §PÂ_¼Æ¦rªº¥¿­t²Å¸¹ / Sgn(number)

  65. ¶Ç¦^©·«×¼Æ¦rªºSin­È / Sin(number)

  66. ²£¥ÍªÅ¥Õ¦r¤¸¦r¦ê / Space(number)

  67. ºâ¼Æ­Èªº¤G¦¸¤è®Ú´Ó / Sqr(number)

  68. ¤ñ¸û¨â¦r¦ê / StuComp(string1,string2[,compare])

  69. ¤Ï¹L¨Ó±Æ¦C¦r¦ê / StrReverse(string)

  70. ²£¥Í­«½Æ¦r¤¸¦r¦ê / String(number,character)

  71. ¶Ç¦^¥Ø«eªº¨t²Î®É¶¡ / Time

  72. ¶Ç¦^®É¶¡Date«¬ºA / TimeSerial(hour,minute,second)

  73. ¶Ç¦^§t®É¶¡ªºDate«¬ºA / TimeValue(time)

  74. ¶Ç¦^Åܼƪº¸ê®Æ«¬ºA / TypeName(varname)

  75. ±q§ÀºÝ¶Ç¦^°}¦C¤p¯Á¤Þ / UBound(anayname)

  76. Âର¤j¼g¦r¤¸ / UCase(string)

  77. ¶Ç¦^¥NªíÅܼƸê®Æ«¬ºAªº¼Æ¦r / VarType(varname)

  78. ¶Ç¦^¤é´Á¬O§«ô´X? / Weekday(date,[firstdayofweek])

  79. ¶Ç¦^¤é´Á¤ºªº¦~¼Æ­È / Year(date)
½Æ»s¥N½X

´±°Ý¶{¥S:
      1)¥H¤W¬OVB¨ç¼Æ,¦bvba¤]¥i¥Î¶Ü?
      2)VB ©M Vba ¦³¦ó®t²§,¦bVB¤¤ªº»yªk,¥i¥H²¾¸m¨ìVBA?
V98

TOP

´±°Ý¶{¥S:
      1)¥H¤W¬OVB¨ç¼Æ,¦bvba¤]¥i¥Î¶Ü?
      2)VB ©M Vba ¦³¦ó®t²§,¦bVB¤¤ªº»yªk,¥i¥H²¾¸m¨ìVB ...
linshin1999 µoªí©ó 2010/12/25 09:18 PM



±z¦n linshin1999¥S.
1.VB6¨ç¼Æ»PExcel VBA¬O¥i¥H¦@³qªº!
2.VB6 »P Excel VBA»yªk¬O¬Û¦Pªº¡A®t²§ÂI¬OVB6¸ûÁͪñ©óª«¥ó¾É¦V
¦Ü©óVB6µ{¦¡ª½±µ·h¨ìExcel VBA(©Î¤Ï¤§) ¬Ò»Ý½Õ¾ã... ¨Ò¦p»¡eventµ¥...
­Y¬O§Ú¦^µª¡A¨Ï±zº¡·N¡A½Ð±zÅý§Úª¾¹D¡I                  
­Y¬O§Úªº¦^ÂСA±z¤´¦³¨ä¥L¨£¸Ñ¡A¤]½Ð±z¤£¶Þ«ü±Ð¡I

TOP

ÁÂÁ¤À¨É
«Ü¦h¸Ì­±ªº¨ç¼ÆÁÙ¨S¥Î¹L
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

¦^´_ 1# Min


    ·s¤â¨Ï¥Î¥ý¦L¥X¨Ó¶K®ÇÃä¨C¤Ñ¬Ý§V¤O¾Ç²ß
·PÁ¤À¨É:D
hihi  = =

TOP

·PÁ¤À¨É¡AÁÙ¦³«Ü¦hªº¦a¤è»Ý­n¾Ç²ß!

TOP

¦^´_ 2# linshin1999

VB ©M Vba ¦³¦ó®t²§,¦bVB¤¤ªº»yªk,¥i¥H²¾¸m¨ìVBA?
vba ¥²¶·¦bexcel ¤U°õ¦æ
¦ýVB ¥i¦¨¬°.exe °õ¦æÀÉ

TOP

        ÀR«ä¦Û¦b : §Ñ¥\¤£§Ñ¹L¡A§Ñ«è¤£§Ñ®¦¡C
ªð¦^¦Cªí ¤W¤@¥DÃD