Microsoft visual basic compile error expected function or variable

For example, if you run code that is supposed to activate an Excel worksheet, but that worksheet is unavailable either deleted or its name changed , your code would give you a runtime error. Unlike with the two previous errors, when a runtime error occurs, the message in the Run-time error dialog box is a little more explicit because it explains the problem and that can help you correct it. The error comes from the fact that two statements have been written in one line instead of two.

The code should be:. As such, the possible reasons for the error are as varied as the number of mistakes that you can make while writing a line of code. How to fix: Check to see if two different statements have inadvertently been put on the same line then send the second statement to a new line. To solve the problem, you just need to put a space between the variables and the concatenation operator.

Search Advanced search…. Search forums. Log in. Install the app. If you forgot your password, you can reset your password. JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding. You are using an out of date browser.

It may not display this or other websites correctly. You should upgrade or use an alternative browser. Thread starter psycoperl Start date Feb 6, I have been getting a Microsoft Visual Basic for Application: Compile error: Expected Function or Variable message when trying to write and test a new module that I am working on.

The Module has 1 function and 1 sub listed below. Ms access. Undesired Name? Follow us! Get the Latest Bytes Updates. By using this site, you agree to our Privacy Policy and Terms of Use. Compile Error: Expected Function or Variable darrel 72 Hello, i need you help, can someone whats the cause of getting an error of Expected function or variable, its like this i have a function code in a module and call it on my main form..

Value Jun 3 '07 reply Message. Cancel Changes. Doesn't compile on my system 4 posts views Thread by Eric Lilja last post: by. General lancet: a comprehensive, efficient, and reusable util function library of go reply views Thread by lanliddd last post: by. However, the report is incorrect because the line is in a section that only runs in Visual Basic for Applications 6. VBA 6. Therefore, you can safely ignore the error message. Skip to main content. This browser is no longer supported.

Download Microsoft Edge More info.