excel macro select from combo/select box
Posted on 2013-10-28
I am looking for advice to select values from a combo box
essentially my macro connects to oracle db and queries a table and allows the user to specify the where claue input field i.e like so
strSQL = "Select projectnum,description from projects where " & InputBox(Prompt:="Your where clause.", _
essentially my where clause statements are contained in another table called queries
here the colomn queries.whereclause contains the actual where clause
how do i create a combo or select box to select the where clause automatically?
any ideas would be great
essentially it should do the following in psueadocode
strSQL = "Select projectnum,description from projects where " & (select queries.whereclause value)
thanks in advance!