Global procedures

[Fire_Chief]

Do I have to dimension a global variable as string, integer etc.?

I Have:

Global my_age , Continue, Street

Should I have:

Global my_age as interger, Continue as string, Street as string
Would the second way use less memory?

 

[Joe4]

Would the second way use less memory?

Yes, because all undeclared variables and variables declared without a data type default to the Variant type, which uses the most memory.

It is always a good idea to declare all your variables, and give them a data type.

If you place "Option Explicit" at the top of your code, it will force you to declare all your variables. This is a great tool to help with debugging, and will quickly find any typos you may have in variable names.

 

[Fire_Chief]

Thank You

 

[Joe4]

You are welcome.

 

[Fire_Chief]

Do I have to use the Dim statement or can I just use..... Global street as string, my_age as interger

 

[Joe4]

For global variables, you would use "Global" or "Public" instead of "Dim" to declare them (and those declarations would be outside of any procedure and are usually placed at the top of your code).

See: http://access-excel.tips/excel-vba-declare-global-variable/

 

[Fire_Chief]

Thank You again. You have been very heplful