Integer Vs Long Confusion

by

An integer declared as an Integer is still type checked as an Integer. The msdn documentation is referencing how the variable is stored internally. On a 32 bit system, an Integer will be stored in 32 BITS not Bytes, while on a 16 bit system the value is stored in a 16 BIT space or register, it would have been stored in 16. Hence the maximum size.

There is no type conversion going on as far as VBA is concerned. An int is an int and a long is a long, even though they now take up just as much space.

More Related Contents:

  1. Loop through files in a folder using VBA?
  2. Wait for Shell to finish, then format cells – synchronously execute a command
  3. How to error handle 1004 Error with WorksheetFunction.VLookup?
  4. How to compare two entire rows in a sheet
  5. how to detect whether VBA excel found something?
  6. Excel tab sheet names vs. Visual Basic sheet names
  7. VBA ServerXMLHTTP https request with self signed certificate
  8. How to add data validation to a cell using VBA
  9. Getting AD Details based on username
  10. Getting the headings from a Word document
  11. Environ Function code samples for VBA
  12. VBA – Convert string to UNICODE
  13. How to break long string to multiple lines
  14. How to loop through all controls in a form, including controls in a subform – Access 2007
  15. How to copy a chart from Excel to PowerPoint?
  16. vba paste not working
  17. FileDialog doesn’t work
  18. How to refer to Excel objects in Access VBA?
  19. mac excel vba loop : from list & then export as pdf
  20. Can Advanced Filter criteria be in the VBA rather than a range?
  21. How to add an embedded image to an HTML message in Outlook 2010
  22. Speed up multiple replacement
  23. Excel Useform: How to hide application but have icon in the taskbar
  24. Reading Web Pages using Excel VBA
  25. Excel VBA: auto click and open file from website
  26. How to get the procedure or function name at runtime?
  27. Copy an array reference in VBA
  28. How to get selected value in multicolumn listbox
  29. What does the To and Step mean in VBA?
  30. Query my excel worksheet with VBA

Leave a Comment