Hi Folks,

I have two sheets. The first contains a db query with two parameters which
the user is prompted to input for if they refresh the query. My second sheet
is an auto-refreshing query with three columns; first column contains an
order number. the second column contains an order code, and the third column
contains an order description.

On my first sheet I have placed a list box that gets it's input range from
the third column on sheet two (order description), and it's cell link from
the first column (order number) on sheet two.

My thought is to place a button on sheet one next to the list box that will
take the order number associated with the selected order description from the
list box and use that as the parameter for my query.

If possible I'd like to keep the form elements directly on the first sheet
whithout having to resort to a user form if it is more effecient. I'm not
sure how to code the button to take the value I need from the list box.

I have another file which take it's query parameter directly from specific
cells on a sheet but my problem is making the leap from cell selected values
to list box selected values to be used as my parameters for my query.

Any help is always greatly appreciated.

Thanks!