Charles,

Ignore this advice and follow Frank's suggestion. It is more direct,
simpler, and more appropriate.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Serkan" wrote in message
...
It's possible. Visit this very handy site...

http://j-walk.com/ss/excel/tips/tip96.htm


-----Original Message-----
Hi is it possible to use vba code to change text in a
module at run time I am using Excel XP, it will be in the
same file. if any body can guide in the right direction
it
will much appreciated.

I am trying to write a sql statment to query a table in
MSAccess but the user can select from three Comboboxes, I
wanted to add the Where string at run time to the code.

TIA
Charles
.