2023 2024 Student Forum > Management Forum > Main Forum

 
  #1  
10th April 2015, 03:09 PM
Unregistered
Guest
 
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.
Similar Threads
Thread
CBSE affiliation code school code examination codes
PTU LC Code
MDU Pin Code
Examination Code School Code Of CBSE Schools
MBA CIP Code
VCU GRE Code
MP RTO Code
UTD GRE Code
SBI NSE Code
Error Code RPC S-5 AEC-0
Lpu pin code
MDU IB Code
NIT KKr Pin Code
IMS BHU Pin Code
NHH GRE code
PNB BIC Code
MBA uwa course code
RTU Pin Code
SBI IMS BHU Code
  #2  
20th February 2016, 10:16 AM
Unregistered
Guest
 
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
Super Moderator
 
Join Date: May 2012
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).


Quick Reply
Your Username: Click here to log in

Message:
Options

Thread Tools Search this Thread



All times are GMT +5. The time now is 10:04 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
SEO by vBSEO 3.6.0 PL2

1 2 3 4