Function Returning Boolean? Function Returning Boolean? vba vba

Function Returning Boolean?


function vba 

function MyFunction() as Boolean    .....    .....    MyFunction = True 'workedend functiondim a as boolean = MyFunction()

function vba

In VBA, you set a function's return value by assign to a variable with the same name as the function:

Function MyFunc() as Boolean    MyFunc = TrueEnd Function

function vba

I suspect you may be using VBScript instead of VBA? If that's the case then VBScript doesn't state Type

this will work in VBScript

dim test,btest = 1b=falsemsgbox ("Calling proc before function test=" & test)msgbox("Calling proc before function b=" & b)b = A(test)msgbox ("Calling proc after function test=" & test)msgbox("Calling proc after function b=" & b)Function A(test)test = test +1  A=trueEnd Function

or in your example

Function A()    A=trueEnd Function

Recent Posts
How can I color dots in a xy scatterplot according to column value?
How to update a claim in ASP.NET Identity?
What does {0} mean when initializing an object?
Accessing members of items in a JSONArray with Java
How to log SQL statements in Spring Boot?
Powershell Get-WebSite name parameter is ignored
How to detect scroll to bottom of html element
Java synchronized method
How to test controllers with CodeIgniter?
Detect Visual Composer
Matplotlib: Specify format of floats for tick labels
Rails join a list of strings with commas and "and" before the last