Parameter Dialog Box
 

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