run time error '5': invalid procedure call or argument

[Malavika1990]

Hi i am working on an application.in where i have to declare a global variable to access a file path of one document and it should be used in different modules.
i declared the global variable and assiged the value to the variable also.

Global FilePath As String
 
Function getFilePath() As String
    getFilePath = FilePath
    FilePath = "C:\quadyster\R3AgreementDetails"
End Function

But while using the global variable it is showing empty value i was not getting where i made the error please show me some solution to that

[twinnyfo]

You need to switch lines 4 and 5:

Public FilePath As String
 
Function getFilePath() As String
    FilePath = "C:\quadyster\R3AgreementDetails"
    getFilePath = FilePath
End Function

Also, I would recommend using the Public statement, rather than Global, as this is a more standard statement.

[NeoPa]

Indeed. In your original code you set getFilePath with FilePath before you'd set FilePath, so it was still an empty string.

Strangely enough, if you'd called it a second time it would have worked ;-)

[Malavika1990]

Thanks for the solutions given i made the changes and it is working fine.