Hi Rakesh, Thanks for your help.
I did not write this code. I found this template from the internet. I tried to correct it and at the end I gave up. I don't have much VB knowledge. This is a great group and everybody is willing to help. Regards, San On Wed, Feb 23, 2011 at 3:09 AM, rakesh kumar <rakeshshail2...@gmail.com>wrote: > *Here it is,* > * > * > *But wondering how did you manage to write such a huge code ?? My reply > has got a little error I didn't look at your code. Had it changed with > xlpart to xlwhole, it would have been all IS OK. * > > > On Tue, Feb 22, 2011 at 11:06 PM, San Pat <myitems2...@gmail.com> wrote: > >> 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 >> > > > > -- > 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