VBA支持的变量类型

No.      Type      Size in Memory      range of values

  1        byte             8 bits                  0 to 255

  2      Boolean       16 bits               True or False

  3      integer         16 bits              -32768  to 32767

  4       Long            32 bits              -2147483648 to 2147483647

  5      Single            32 bits             approx. -3.4E38 to 3.4E38

  6      double           64 bits             approx. -1.8E308 to 4.9E324

  7      currency        64 bits              approx. -9223372036854775808 to 9223372036854775807

  8      Date              64 bits              1/1/100 to 12/31/9999

  9      Object            32 bits             Any object reference

 10      String           

 11      variant

 12     User defined

 

 

从这里看, 必要的数据类型都支持... 晕了