Pass a string to a Excel Macro??

Is it possible to pass a sting to an Excel Macro?


I can open the macro but I can't pass a sting to it.

You can't call the macro with a parameter??
OR
You can't specify in the macro that a parameter has been entered??

If you put

Sub Macro1 (myString as String)

then the macro will be expecting a parameter.