Passing Variables into VBA Function through Invoke VBA

I have written a function in VBA code and want to pass some variables into that function then want use within VBA function. How to pass through EntryMethodParameter Property of Invoke VBA

Public Function Demo(String1 as String, Strin2 as String)
Dim sheet As Worksheet
MsgBox(String1 + " " +String2)
End Function

1 Like

Variables from studio will be pass in EntryMethodParameters

and in code

sub Mac(Var1,Var2)

1 Like

Sorry, there is a little mistake in variable name. Now it is printing, Thanks

Happy Automation

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.