David
There is a parameter toolbar button on the External Data bar. Click it, and
you can change the prompt string and a few other options. See here for more
info.
http://www.dicks-clicks.com/excel/Ex...htm#Parameters
--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com
"David" wrote in message
...
I have created a query that is going to be executed by a command button.
And when i ask my question for the user. I just placed a question mark.
When the query runs, a parameter dialog box opens, and says "Parameter1".
What command (keyword) do i use to override "Parameter1".
Thanks