What is wrong with this variable with initial value , Excel VBA

Question

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.

Possible Duplicate [Of This Question](http://stackoverflow.com/questions/3256122/can-i-simultaneously-declare-and-assign-a-variable-in-vba) — user2140261, Oct 16 '13 at 14:42
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, Oct 16 '13 at 15:43

score 2 · Accepted Answer · edited Oct 16 '13 at 15:42

2

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

edited Oct 16 '13 at 15:42

David Zemens

answered Oct 16 '13 at 14:48

Running Forward

score 1 · Answer 2 · answered Oct 16 '13 at 14:40

1

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

answered Oct 16 '13 at 14:40

dezzie

user2140261 · Answer 3 · 2013-10-16T15:07:53.200

1

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

enter image description here

edited Oct 16 '13 at 15:07

answered Oct 16 '13 at 14:43

user2140261

1

@user2703472 Added a ScrenShot of code in action when you say didn't work what happened?? – user2140261 Oct 16 '13 at 15:08

3 Answers3