Please help me a new user on how to create a list box on a worksheet,
pass the selection to a query in VB.

For example:

In this query select name from x where y 1000

I need to be able to select the "name" from the list box and pass it t
the query. The pupose is to be able to dynamically select items in th
database at random

Also, how do I do the second part? If I type y 1000 can that stin
be passed to the query? How is that done and what is the syntax ..
specially on the VB side?

Any help will be much appreciated.

Thanks in advance,

~Anush

--
Anush
-----------------------------------------------------------------------
Anusha's Profile: http://www.excelforum.com/member.php...fo&userid=2711
View this thread: http://www.excelforum.com/showthread.php?threadid=46631