Code Red > VB(A)

Var from command line to VBA routine

(1/1)

jura:
Is it possible to transfer a var from a the commmand line to a simple VBA routine.

Here is what i want to do, this doesn't work, but should give you some idea.

Command line:

--- Code: ---
^C^C-vbarun QuadrantToggle(16)

--- End code ---


VBA routine

--- Code: ---
Sub QuadrantToggle(VarName)
Dim VarName As Integer

'routine here

End Sub

--- End code ---

SMadsen:
I'm not really into menu macros but you could probably use VBASTMT. I can't get it to work directly but this seems to work:

^C^C(command "VBASTMT" "QuadrantToggle(16)");

jura:
Works like a charm!!!!

Thx a lot.

This saves a lot of reprogramming. One routine can do so much more now.

Navigation

[0] Message Index