Dears,

I'd like to create a TextBox and allow users to enter an expression, for
instance,
CompanyName = 'ABC' AND DeptName = '" & C1 & "' AND EmployeeName = '" &
NamedRange1 & "'"

This is a where clause like expression and I'd like to get the cell
reference / name range reference in my code. Is there any method that I can
use to evaluate an expression and obtain the actual values and then concat to
my SQL string? Or I have to use InStr or other indirect methods to create an
expression?

Thanks a lot!