VBA

The UK's most regular instructor-led training courses.
Training information: visual+basic+for+excel+courses+london · Microsoft+excel+training · VBA courses London

Resolved · Low Priority · Version 2003

VBA

David has attended:
Excel VBA course
Excel VBA course

by - delegate David [1 post] (2008 Apr 17 Thu, 16:33) Reply

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?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Jul 8 Tue	Bloomsbury	0	FULL
2003/XP	2008 Jul 8 Tue	Bayswater	1	book now	£195	£205
2003/XP	2008 Jul 9 Wed	Bloomsbury	3	book now	£210	£215
2003/XP	2008 Jul 15 Tue	Bloomsbury	3	book now	£210	£215
2003/XP	2008 Jul 15 Tue	Tooting	0	FULL
2007	2008 Jul 16 Wed	Bloomsbury	7	book now	£202	£224
Full Schedule: See all 160 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

VBA Variables

by - trainer Carlos gold contributer [360 posts] (2008 Apr 21 Mon, 09:44) Reply

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