Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Declaration w initialization - for dummies
Hello,
how do I declare and initialize at the same time? If I cannot use 'Dim boolVar as boolean = false' - what is correct, then? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Declaration w initialization - for dummies
Hi
When you declare a boolean variable, it is False by default. Just use: Sub Test Dim boolVar as Boolean Debug.Print boolVar' See the value of the variable in the immediate window End Sub Regards, Per "Mac" skrev i meddelelsen ... Hello, how do I declare and initialize at the same time? If I cannot use 'Dim boolVar as boolean = false' - what is correct, then? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Declaration w initialization - for dummies
Hi Mac
--Unlike many other languages, VBA or even VB does not allow you to initialize variables; this must be done with a separate executable statement. --Each variable does have a default initialization value. Numeric variable types are initialized to zero, Strings are initialized to "" or vbNullString, Booleans are initialized to False and so on... --VB .NET allows you to initialize variables in the declaration. Dim x As Single = 1.23 Dim txt As String = "This is a test" -- Jacob "Mac" wrote: Hello, how do I declare and initialize at the same time? If I cannot use 'Dim boolVar as boolean = false' - what is correct, then? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Declaration w initialization - for dummies
I thought as much, glad to have it confirmed. Thank you!
"Jacob Skaria" wrote: Hi Mac --Unlike many other languages, VBA or even VB does not allow you to initialize variables; this must be done with a separate executable statement. --Each variable does have a default initialization value. Numeric variable types are initialized to zero, Strings are initialized to "" or vbNullString, Booleans are initialized to False and so on... --VB .NET allows you to initialize variables in the declaration. Dim x As Single = 1.23 Dim txt As String = "This is a test" -- Jacob "Mac" wrote: Hello, how do I declare and initialize at the same time? If I cannot use 'Dim boolVar as boolean = false' - what is correct, then? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to use for dummies | New Users to Excel | |||
VBA for Dummies? | Excel Discussion (Misc queries) | |||
Macros for dummies?? | New Users to Excel | |||
Macros for Dummies | Excel Discussion (Misc queries) | |||
TreeView for Dummies | Excel Programming |