My worksheet has a cell which takes a keyword from the user and then
uses that keyword to Advance Filter a list. The problem is I want to
automatically add a wildcard character to that keyword before it is
filtered, but don't know how to do it. The best coding I can come up
with simply replaces the whole cell contents instead of just adding
characters to it. So what I want to achieve is:

1. User enters a keyword into the cell
2. Once they deselect that cell its contents are automatically changed
to "*keyword*"

any ideas? Thanks in advance


--
anar_baku
------------------------------------------------------------------------
anar_baku's Profile: http://www.excelforum.com/member.php...o&userid=18259
View this thread: http://www.excelforum.com/showthread...hreadid=399471