Working in VBA, I cannot assign a string to an initlialized string variable (compiling error: expected end of statement)

Question

I am working in a module in access trying to initialize variables. For some reason the declaration:

Dim ModName As String = "modWindowsFileSystem"

creates a compiling error at the '=' with the error message "Expected:end of statement". I have looked up the format on mutiple websites that all agree with my syntax here is a trustworthy one: http://msdn.microsoft.com/en-us/library/7ee5a7s1.aspx Another website suggested I declare the variable within a function such as

Sub AssignValueString()
   Dim Modname As String
   Modname = "modWindowsFileSystem"
End Sub

but that seems unnecessary. One issue that may be considered is I have saved the module and named it modWindowsFileSystem. I am not sure if this will conflict somehow with initializing that variable.

Unfortunately, VBA and VB.NET are very similar but not entirely the same. That syntax is correct for VB, but not VBA. — bamblack
– bamblack, Commented Jun 4, 2014 at 13:46

armstrhb · Accepted Answer · 2014-06-04 15:00:38Z

4

VBA is a little different from VB. The msdn link you posted is actually for VB, which allows for inline declarations and assignment. VBA won't allow this, unfortunately.

So, you can either split them, like your example:

Dim Modname As String
Modname = "modWindowsFileSystem"

Or, you can place the continuation character : to achieve this on one line.

Dim Modname As String : Modname = "modWindowsFileSystem"

As far as the assignment for a module's variables, you can declare global variables outside of a function, but you would need to set their value within a function, like an init() function. Constants (labelled with Const) can be declared and assigned outside of a function.

edited Jun 4, 2014 at 15:00

answered Jun 4, 2014 at 13:47

armstrhb

4,1923 gold badges23 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

VictoriaJay Over a year ago

Do you know if I have to initialize the variable within a subfunction?

armstrhb Over a year ago

For modules, you can declare global variables outside of a function, but you would need to set their value within a function, like an init() function. Constants (labelled with Const) can be declared and assigned outside of a function.

user2140173 Over a year ago

@armstrhb +1 your last comment should really be part of your answer :)

Collectives™ on Stack Overflow

Working in VBA, I cannot assign a string to an initlialized string variable (compiling error: expected end of statement)

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related