Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » VBA
|
|
|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
VBA
Resolved · Low Priority · Version 2003
Reply Thu 17 Apr 2008, 16:33Delegate David said...
David has attended:
Excel VBA Intro Intermediate course
Excel VBA Intro Intermediate course
VBA
I still do not understand the need for all the Bytes, Long, integer, String Variable Length String Fixed length Variant String and Variant Numeric. Are these classifications only to save on memory usage. Surely any variable of any length should be standard?
For upcoming training course dates see: Pricing & availability
VBA Variables
Hi David
You are right. Vriables can be declared as
Dim MyVariable
with no data type. Thia will default it to a Variant type (A standard +22 byte size).
However to save memory usage in the running of the code data types were introduced.
Remember that VBA has been around from the time when 64Mb & 128Mb RAM were considered very large and top technology, so programers had to find ways to reduce memory usage.
Hope this helps
Carlos
|