#1
10th April 2015, 03:09 PM
| |||
| |||
DIM VBA Code
What Does Dim Mean when we are doing Coding for VBA Macros. I am doing Ecommerce from NIIT and doing special course on VBA coding. DIM in VBA is confusing me little bit. If any programmer bro is here pls update me with your knowledge.
|
#2
20th February 2016, 10:16 AM
| |||
| |||
Re: DIM VBA Code
I have no knowledge of DIM VBA code . can you solve my query i.e. what is the DIM why people use VBA code . ?
|
#3
20th February 2016, 10:16 AM
| |||
| |||
Re: DIM VBA Code
Hello bro. as we have knowledge about DIM VBA Code here we provides you as follows Dim is short for the word Dimension and it allows you to declare variable names and their type. The functions you use in VBA can come from three sources: Built-in functions provided by VBA Worksheet functions provided by Excel Custom functions that you (or someone else) write, using VBA Dim is often found at the beginning of macro codes and has the following format: Integer Integer variables are used to store whole numbers. String String variables are used to store text. Double A variable of type Double is more accurate than a variable of type Integer and can also store numbers after the comma. Boolean Use a Boolean variable to hold the value True or False. Range – Stores an Excel range Long – Has the ability to store any number between (2,147,483,647) to 2,147,483,647 Worksheet – Stores a Worksheet VBA functions that do more than return a value A few VBA functions go above and beyond the call of duty. Rather than simply return a value, these functions have some useful side effects. Table 1 lists them. MsgBox Displays a handy dialog box containing a message and buttons. The function returns a code that identifies which button the user clicks. InputBox Displays a simple dialog box that asks the user for some input. The function returns whatever the user enters into the dialog box. Shell Executes another program. The function returns the task ID (a unique identifier) of the other program (or an error if the function can't start the other program). |