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