How to Edit Cell Text
 

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

How to Edit Cell Text
 

How about you use another cell for your criteria cell with a formula like
this in it: ="*"&A1&"*" where A1 is the cell the user made his entry?

--
Jim
"anar_baku" wrote
in message ...

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