filmov
tv
Rules in defining excel VBA variables

Показать описание
Title: Rules in defining excel VBA variables
Recommended Excel VBA books
===================================================
====================================================
Excel VBA Variables are the storage location of your values in the computer memory.Variable should be declared with Dim statement as prefix and followed by its datatype (optional).
In this video, you'll learn the rules in defining excel VBA variables
1) The length of the variable must be less than 255 characters
2) Space or periods are not allowed
3) Special characters like (#, $, %, &,!) is not acceptable
4) The first character must not be numeric or underscore E.g. Dim Variable_first, Variable_last
5)It should not be any reserved keywords E.g. Dim for,set
Recommended Excel VBA books
===================================================
====================================================
Excel VBA Variables are the storage location of your values in the computer memory.Variable should be declared with Dim statement as prefix and followed by its datatype (optional).
In this video, you'll learn the rules in defining excel VBA variables
1) The length of the variable must be less than 255 characters
2) Space or periods are not allowed
3) Special characters like (#, $, %, &,!) is not acceptable
4) The first character must not be numeric or underscore E.g. Dim Variable_first, Variable_last
5)It should not be any reserved keywords E.g. Dim for,set