You can edit the query and instead of leaving the criteria for that field blank, you can place a ? in the criteria for that column identifying it as a paramater.
When you first run the query you can enter any parameter you like, but you can then edit the query properties once back in excel and tell it to look at a cell on the sheet for the parameter (and also set it to auto-refresh if the value changes, or on file open etc)