can you please point me where in the code I have to put this new condition.
I am new to VB. I will appreciate if you can modify my code. Regards, san On Mon, Feb 21, 2011 at 11:12 PM, rakesh kumar <rakeshshail2...@gmail.com>wrote: > *Just put one more condition for if length search term = length found..* > > > On Tue, Feb 22, 2011 at 9:05 AM, San Pat <myitems2...@gmail.com> wrote: > >> Hi >> >> I have a macro with a command button "ClosePosition" in the Sheet >> "OpenPosition" to close my OpenPosition. See the attached file. >> >> It is working fine when I enter a exact match. For example, when I enter a >> exact word as my column 3, there is no issue. >> >> But when I enter only "T", it is showing incorrect output in my listBox. >> It supposed to find only symbol "T". However, it is showing "MOTR" in the >> listBox, because it has a T alphabet in it. See the screen shot in excel. >> >> Please advice which code needs to be fix. >> >> Regards, >> San >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > > > -- > Rakesh kumar khowal > +91 9540084660 > +91 9868532105 > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
