$$Excel-Macros$$ Re: Need Help in AutoComplete with Custom List

Hi Please refer link for details: Link Rgds//Vabs On Tuesday, September 25, 2012 3:24:58 PM UTC+5:30, Manoj Kumar wrote: > > Hi, > > Is there an way to autocomplete the words from the custom list. When > someone type the first word, th

Re: $$Excel-Macros$$ Re: Need Help in AutoComplete with Custom List

Not able to understand clearly. can you please the solution in the attached file. On Tue, Sep 25, 2012 at 5:07 PM, Vabz wrote: > Hi > > Please refer link for details: > > Link > > > Rgds//Vabs > > On Tuesday, September 25, 2012 3:24:58 PM

Re: $$Excel-Macros$$ Re: Need Help in AutoComplete with Custom List

Hi, Attached is the solution based on link provided by Vabz. But it only work for consecutive cells. Other solution is use "Data Validation". It will not give you auto complete option. It will give you dropdown for cell and user have to select value from drop down. Regards, Swapnil. On Tue, Se

Re: $$Excel-Macros$$ Re: Need Help in AutoComplete with Custom List

Thnks for reply. The validation list need to be updated in regular basis and also i have very long list and also can not hide too much rows in the sheet. Is there any VBA solution for this? I am looking for quite a long time and but didnot manage to get it. On Tue, Sep 25, 2012 at 5:40 PM, Swap

RE: $$Excel-Macros$$ Re: Need Help in AutoComplete with Custom List

-Macros$$ Re: Need Help in AutoComplete with Custom List Hi, Attached is the solution based on link provided by Vabz. But it only work for consecutive cells. Other solution is use "Data Validation". It will not give you auto complete option. It will give you dropdown for cell and us

Re: $$Excel-Macros$$ Re: Need Help in AutoComplete with Custom List

ber 2012 5:40 > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Re: Need Help in AutoComplete with Custom > List > > ** ** > > Hi, > > > > Attached is the solution based on link provided by Vabz. But it only work > for consecutive