To get a parameter passed in remove the argument you have added and add some
code to prompt for a value similar to this

Sub LoadData()
dim dt as string

dt = inputbox("Please enter the date")

--
HTH...

Jim Thomlinson


"kmbarz" wrote:

I have my macro all set to format a report. The last thing I had to do was
pass in the date of the report since the ETL happens elsewhere. So, when I
took:

Sub LoadData()

and changed it to

Sub LoadData(dt As String)

the macro name disappeared from my run macro list and the script that calls
it can't see it either. Is there some way to pass a parameter into a macro
like this?