VBA Sub Procedure argument from Key-In ?

[Vikas Bhatia]

I have a sub procedure in VBA which requires arguments and I want to
pass these arguments through key-in 'VBA RUN'.

Example:
Sub Test(X As Integer)
---
---
End Sub

Is there any trick where I could pass the value of X to Test() from
Key-In,
Say, 'VBA RUN Test 123' ?

There was another way in Microstation Basic Macro using Command$
function (command line argument), but VBA doesn't seems supporting
Command$ Function.

Thanks,
Vikas

[Dave Preston]

You should be able to do exactly what you have stated. I have only done it
with sub main:-
-
vba run main newdesk

To check the arguments passed use the KeyinArguments function
--

Regards
Dave Preston
***@cadesignservices.co.uk

www.cadesignservices.co.uk

Post by Vikas Bhatia
I have a sub procedure in VBA which requires arguments and I want to
pass these arguments through key-in 'VBA RUN'.
Sub Test(X As Integer)
---
---
End Sub
Is there any trick where I could pass the value of X to Test() from
Key-In,
Say, 'VBA RUN Test 123' ?
There was another way in Microstation Basic Macro using Command$
function (command line argument), but VBA doesn't seems supporting
Command$ Function.
Thanks,
Vikas

[Vikas Bhatia]

Got It !!! I didn't notice KeyinArguments before.

Thanks Dave,
Vikas

Post by Dave Preston
You should be able to do exactly what you have stated. I have only done it
with sub main:-
-
vba run main newdesk
To check the arguments passed use the KeyinArguments function
--
Regards
Dave Preston
www.cadesignservices.co.uk

Post by Vikas Bhatia
I have a sub procedure in VBA which requires arguments and I want to
pass these arguments through key-in 'VBA RUN'.
Sub Test(X As Integer)
---
---
End Sub
Is there any trick where I could pass the value of X to Test() from
Key-In,
Say, 'VBA RUN Test 123' ?
There was another way in Microstation Basic Macro using Command$
function (command line argument), but VBA doesn't seems supporting
Command$ Function.
Thanks,
Vikas

[Dave Preston]

You're welcome

--

Regards
Dave Preston
***@cadesignservices.co.uk

www.cadesignservices.co.uk

Post by Vikas Bhatia
Got It !!! I didn't notice KeyinArguments before.
Thanks Dave,
Vikas

Post by Dave Preston
You should be able to do exactly what you have stated. I have only done it
with sub main:-
-
vba run main newdesk
To check the arguments passed use the KeyinArguments function
--
Regards
Dave Preston
www.cadesignservices.co.uk

Post by Vikas Bhatia
I have a sub procedure in VBA which requires arguments and I want to
pass these arguments through key-in 'VBA RUN'.
Sub Test(X As Integer)
---
---
End Sub
Is there any trick where I could pass the value of X to Test() from
Key-In,
Say, 'VBA RUN Test 123' ?
There was another way in Microstation Basic Macro using Command$
function (command line argument), but VBA doesn't seems supporting
Command$ Function.
Thanks,
Vikas