I dot know why, Excel throws an error at this line:
Dim yearnr As Integer = 18
I want to declare a variable and assign a initial value. Please tell me why it is not working.
-
1Possible Duplicate Of This Questionuser2140261– user21402612013-10-16 14:42:50 +00:00Commented Oct 16, 2013 at 14:42
-
Could you ... add.. the error message?Jens Bergvall– Jens Bergvall2013-10-16 14:50:05 +00:00Commented Oct 16, 2013 at 14:50
-
When you say the answers offered below "didn't work" please indicate what happens. Is there an error message? Etc. All of the answers provided are syntactically correct. If they are not working, I suspect you are not implementing them correctly.David Zemens– David Zemens2013-10-16 15:43:12 +00:00Commented Oct 16, 2013 at 15:43
Add a comment
|
3 Answers
In VBA the above format is not possible
only constants can be used like this :
Const yearnr As Integer = 18
you can use
Dim yearnr As Integer
yearnr = 18
Public yearnr As Integer
yearnr = 18
Comments
Excel doesn't let you initialize values at declaration as they're already initialized to zero. To do what you want just break it up into two lines.
Dim yearnr As Integer
yearnr = 18
Comments
Looking at the Question in my comment, For you needs it would be:
Dim yearnr As Integer: yearnr = 18
you can make it one line with the : character
1 Comment
user2140261
@user2703472 Added a ScrenShot of code in action when you say didn't work what happened??