What does the $ symbol do in VBA?

by

Here is a Cheat Sheet for DataTypes

Variable End with:

$ : String
% : Integer (Int16)
& : Long (Int32)
! : Single
# : Double
@ : Decimal

Start with:

&H : Hex
&O : Octal

Comparison between VB and VB.Net (reference)

Visual Studio .Net added Literal Types (reference)

Value End with: (For more complete list, refer the the reference)

S : Short (Int16)
I : Integer (Int32)
L : Long (Int64)
F : Single
R : Double
D : Decimal

More Related Contents:

  1. How can I assign a Variant to a Variant in VBA?
  2. Why Use Integer Instead of Long?
  3. How to error handle 1004 Error with WorksheetFunction.VLookup?
  4. How can Excel VBA open file using default application
  5. How to compare two entire rows in a sheet
  6. Run same excel macro on multiple excel files
  7. VBA : save a file with UTF-8 without BOM
  8. IsDate function returns unexpected results
  9. Saving a Excel File into .txt format without quotes
  10. Excel VBA “Method ‘Document’ of object ‘IWebBrowser2’ failed”
  11. VBA – Range to jpg picture
  12. vba listbox multicolumn add [duplicate]
  13. Fastest way to delete rows which cannot be grabbed with SpecialCells
  14. Combine multiple Excel workbooks into a single workbook
  15. Excel Macro, inserting internationally valid formula during run-time
  16. VBA Internet Explorer Automation – How to Select “Open” When Downloading a File
  17. Making VBA Form TextBox accept Numbers only (including +, – and .)
  18. VBA Convert date to week number
  19. Inserting an Online Picture to Excel with VBA
  20. Change length of For loop while in the loop
  21. VBA – Run Time Error 1004 ‘Application Defined or Object Defined Error’
  22. Consolidating worksheets into one
  23. Copy filtered data to another sheet using VBA
  24. Range.Find on a Date That is a Formula
  25. How do I sort a collection?
  26. Range() vs Cells() vs Range.Cells()
  27. In Excel VBA, what is the way to check if the web page is fully loaded?
  28. How do I get a list of unique values from a range in Excel VBA?
  29. How to get selected value in multicolumn listbox
  30. Query my excel worksheet with VBA

Leave a Comment