Hello everybody, I have a problem that I can't increase the list range , I can't find value (Range name "List") Please help.
Regards On Thursday, April 25, 2013 12:54:17 PM UTC+5:30, Abhi wrote: > Please see the attached. > > First sheet (List) has the list of items wherein the VBA would search to > pick up values from. There are items in 3 columns. You can add more columns > or items in existing columns but make sure to adjust the range value (Range > name "List") according to your changes. > > Second Sheet (Issue) is where the VBA is triggered upon selection of > highlighted cells (where items are to be put). You would see in the form > list that all items are appearing column wise, i.e., first the items of Col > A then of B and so on. Type the first letters, select as you go and press > enter. > > I hope this solves your purpose. > > Cheers! > > AJ > > On Thu, Apr 25, 2013 at 12:21 PM, Mathan <matha...@gmail.com <javascript:> > > wrote: > >> Hi, >> >> Can we do this using VBA macro? I understand that excel will struggle >> while searching. But is it possible? If yes, could anyone help me out? >> Thanks >> >> >> On Wed, Apr 24, 2013 at 2:45 PM, Kanwaljit Singh <kanw...@gmail.com >> <javascript:>> wrote: >> >>> Hello Sir, >>> >>> What I understand that is >>> --You are using a Validation List >>> --You want that When you start typing in the cell, the entries in >>> validation list start reducing to those matching the words, like a >>> wild-card search. >>> >>> It that is true, I don't think there is any Excel Add-in for such >>> purpose. You can try Google Spreadsheets. >>> Create a range there. Use the range as Validation List. When you start >>> typing in the cell, the list will automatically adjust to match with the >>> typed words. It is unfortunate the MS has not provided any such >>> functionality till date. >>> >>> On Sat, Apr 13, 2013 at 12:32 AM, Mathan <matha...@gmail.com >>> <javascript:>> wrote: >>> >>>> Hello Experts, >>>> >>>> I am looking for an excel add-in that will enable Autocomplete from any >>>> column or Sheet within a workbook >>>> >>>> For example, lets say i have a sheet called "Accounts" where I have the >>>> following: >>>> A1 - Office Supplies >>>> A2 - Marketing >>>> A3 - Auto Expense >>>> A4 - Payroll >>>> >>>> If I go to *A5* and start typing "Off..." then "Office Supplies" will >>>> show as an option. I want to be able to do this in ANY cell from any >>>> column even from another sheet >>>> I am not talking about Data validation or ComboBox... just the Excel >>>> Autocomplete that works within the same column. >>>> >>>> I'm trying with my knowledge but I feel this is an advanced task which >>>> I could not get so far. ATTACHED THE SCREENSHOT OF THE EXAMPLE. >>>> >>>> Thanks in advance. >>>> >>>> Regards, >>>> Mathan >>>> >>>> -- >>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>>> https://www.facebook.com/discussexcel >>>> >>>> FORUM RULES >>>> >>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>>> will not get quick attention or may not be answered. >>>> 2) Don't post a question in the thread of another member. >>>> 3) Don't post questions regarding breaking or bypassing any security >>>> measure. >>>> 4) Acknowledge the responses you receive, good or bad. >>>> 5) Jobs posting is not allowed. >>>> 6) Sharing copyrighted material and their links is not allowed. >>>> >>>> NOTE : Don't ever post confidential data in a workbook. Forum owners >>>> and members are not responsible for any loss. >>>> --- >>>> You received this message because you are subscribed to the Google >>>> Groups "MS EXCEL AND VBA MACROS" group. >>>> To unsubscribe from this group and stop receiving emails from it, send >>>> an email to excel-macros...@googlegroups.com <javascript:>. >>>> To post to this group, send email to excel-...@googlegroups.com >>>> <javascript:>. >>>> Visit this group at http://groups.google.com/group/excel-macros?hl=en. >>>> For more options, visit https://groups.google.com/groups/opt_out. >>>> >>>> >>>> >>> >>> >>> >>> -- >>> Sincere Regards >>> CA Kanwaljit Singh Dhunna >>> +91-987 6739 911 >>> +91-950 1031 007 >>> >>> -- >>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>> https://www.facebook.com/discussexcel >>> >>> FORUM RULES >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>> will not get quick attention or may not be answered. >>> 2) Don't post a question in the thread of another member. >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> 4) Acknowledge the responses you receive, good or bad. >>> 5) Jobs posting is not allowed. >>> 6) Sharing copyrighted material and their links is not allowed. >>> >>> NOTE : Don't ever post confidential data in a workbook. Forum owners and >>> members are not responsible for any loss. >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "MS EXCEL AND VBA MACROS" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to excel-macros...@googlegroups.com <javascript:>. >>> To post to this group, send email to excel-...@googlegroups.com >>> <javascript:>. >>> Visit this group at http://groups.google.com/group/excel-macros?hl=en. >>> For more options, visit https://groups.google.com/groups/opt_out. >>> >>> >>> >> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to excel-macros...@googlegroups.com <javascript:>. >> To post to this group, send email to excel-...@googlegroups.com >> <javascript:>. >> Visit this group at http://groups.google.com/group/excel-macros?hl=en. >> For more options, visit https://groups.google.com/groups/opt_out. >> >> >> > > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
