ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Declaration w initialization - for dummies (https://www.excelbanter.com/excel-programming/437308-declaration-w-initialization-dummies.html)

Mac

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?

Per Jessen

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?



Jacob Skaria

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?


Mac

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?



All times are GMT +1. The time now is 04:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com