Is it possible to set the value of the 'value' criteria with MSQuery using
data entered into a UserForm in Excel?

What i would like to do is to have a variable for the Like value in MS query
and the value of this variable is set in a UserForm in excel.

I have a macro which displays a UserForm into which i would like the enter
the criteria. The macro then runs the desired MS Query but i am unable to
refine the query using the information entered in to the Textbox. When i use
this variable to define the 'Where' part of the 'Select' 'From' 'Where'
function the Query errors.