Re: $$Excel-Macros$$ List Box Like Tally Software
For the position, use Private Sub UserForm_Activate() Me.Top = 150 Me.Left = 250 End Sub adjust it based on your requirement... to make it dynamic for any excel application or screen size, you'll have to use API For ISERROR problem in Excel 2003, use =IF(ISERR(INDEX(Data!$A$3:$A$640,SMALL(IF(IFERROR(SEARCH($E$1,Data!$E$3:$E$640,1),0)0,ROW(Data!$E$3:$E$640)-2,),ROW()-4))),,INDEX(Data!$A$3:$A$640,SMALL(IF(IFERROR(SEARCH($E$1,Data!$E$3:$E$640,1),0)0,ROW(Data!$E$3:$E$640)-2,),ROW()-4))) in A5 and drag formula across Regards, Sam Mathai Chacko On Mon, Feb 27, 2012 at 10:57 AM, chandra sekaran duraichan...@gmail.comwrote: Dear all this file not working with excel2003 iserror function regards chandru On Mon, Feb 20, 2012 at 8:28 PM, Maries talk2mar...@gmail.com wrote: Hi, I got your logic. Check the attachment. Type your text in cell D1 Enter. It will give answer. Regards, MARIES. On Mon, Feb 20, 2012 at 4:39 PM, chandra sekaran duraichan...@gmail.comwrote: Hi maries, thanks for your Reply, MyOutput Sheet D1 Activate then My List of Cutomer may shwon seperate list box or Below D1 Cell there itself we want to select or like sheet Name Tally List box like that if possible [ First time i do not know what are the customer are there in my Data so once D1 is Activate Unique My Cutomer will display if possible please Regards chandru On Mon, Feb 20, 2012 at 5:54 PM, Maries talk2mar...@gmail.com wrote: Hi, Find the attached file. If you type first name in search cell, respective datas will show below. Regards, MARIES. On Mon, Feb 20, 2012 at 2:03 PM, chandra sekaran duraichan...@gmail.com wrote: Dear all Here with attached List Box like Tally is this possible with excelonce Active List box or Cell shown under all name after enter first letter than showing start with all names like that Advance Thanks for all Regards chandru -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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
RE: $$Excel-Macros$$ List Box Like Tally Software
Hi Chandra, I think the iserror formula from Sam was not completely converted for Excel 2003. It still contained IFERROR in parts. This should work. Enter it at cell A5 on the MyOutput sheet and copy to all the formula cells there. I modified the formula slightly so it will work unchanged in all columns (I removed the $ signs in front of columns in the range Data!$A$3:$A$640 to make the column reference relative). =IF(ISERROR(INDEX(Data!A$3:A$640,SMALL(IF(IF(ISERROR(SEARCH($E$1,Data!$E$3:$ E$640,1)),0,SEARCH($E$1,Data!$E$3:$E$640,1))0,ROW(Data!$E$3:$E$640)-2,),R OW()-4))),,INDEX(Data!A$3:A$640,SMALL(IF(IF(ISERROR(SEARCH($E$1,Data!$E$3: $E$640,1)),0,SEARCH($E$1,Data!$E$3:$E$640,1))0,ROW(Data!$E$3:$E$640)-2,), ROW()-4))) Make sure to array enter it with Ctrl-Shift-Enter in a single cell and copy to the other cells. Also note that the formula is in cells that appear blank all the way down to row 22. Replace that formula with the new one for all those cells. There are a few other compatibility issues Excel detected: .On the Data sheet, the data validation rules refer to named ranges in another workbook. This is not supported in Excel 2003, and the data validation in columns F-K will not work or will be deleted. Column F's data validation rule is ALLOW: List (ignore blank, in-cell dropdown) SOURCE =staOne. Column G's is the same with SOURCE =Month. Column H's is the same with SOURCE =Status. Column I's is the same with SOURCE =Month again. Column J's is the same with SOURCE =Plant. Column K's is the same with SOURCE =Product. If you want those data validation lists, you'll need to put those lists in the same workbook and update the named ranges to point to them, then recreate the data validation rules if Excel deleted them. .The conditional formats used on the Data sheet are specified in such a way that multiple formats could apply to the same cells simultaneously. It looks to me that the formats are the same for all the formatting rules, so this was probably a mistake. But I didn't confirm this positively, so if the formats are intended to be merged, this is not possible in Excel 2003. If needed, you could achieve the exact same formatting effect by using more rules that each have all the combinations of conditions and formats. Again though, my cursory examination seems to indicate that this is a non-issue in reality. .Some formatting used is not supported and will be changed. I leave it as an exercise for you to make these few changes.. if you really need someone to make them for you or there is still a compatibility issue, just post back :) Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of chandra sekaran Sent: Monday, February 27, 2012 9:03 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ List Box Like Tally Software hi all I thank Marrie, SAM he helped lot thing with out him i am not get this . once again i thank to him, the same time i want ask can you convert to this file to excel 2003 i tried your advice but it won't work please... Regards chandru On Mon, Feb 27, 2012 at 8:37 PM, Maries talk2mar...@gmail.com wrote: For Speedup, Use below Tuneup codes. With Application .Calculation=xlCalculationManual .ScreenUpdating=False ' Main Coding .Calculation=xlCalculationAutomatic .ScreenUpdating = True End With Regards, MARIES. On Mon, Feb 27, 2012 at 5:35 PM, Sam Mathai Chacko samde...@gmail.com wrote: For the position, use Private Sub UserForm_Activate() Me.Top = 150 Me.Left = 250 End Sub adjust it based on your requirement... to make it dynamic for any excel application or screen size, you'll have to use API For ISERROR problem in Excel 2003, use =IF(ISERR(INDEX(Data!$A$3:$A$640,SMALL(IF(IFERROR(SEARCH($E$1,Data!$E$3:$E$6 40,1),0)0,ROW(Data!$E$3:$E$640)-2,),ROW()-4))),,INDEX(Data!$A$3:$A$640, SMALL(IF(IFERROR(SEARCH($E$1,Data!$E$3:$E$640,1),0)0,ROW(Data!$E$3:$E$640)- 2,),ROW()-4))) in A5 and drag formula across Regards, Sam Mathai Chacko On Mon, Feb 27, 2012 at 10:57 AM, chandra sekaran duraichan...@gmail.com wrote: Dear all this file not working with excel2003 iserror function regards chandru On Mon, Feb 20, 2012 at 8:28 PM, Maries talk2mar...@gmail.com wrote: Hi, I got your logic. Check the attachment. Type your text in cell D1 Enter. It will give answer. Regards, MARIES. On Mon, Feb 20, 2012 at 4:39 PM, chandra sekaran duraichan...@gmail.com wrote: Hi maries, thanks for your Reply, MyOutput Sheet D1 Activate then My List of Cutomer may shwon seperate list box or Below D1 Cell there itself we want to select or like sheet Name Tally List box like that if possible [ First time i do not know what are the customer are there in my Data so once D1 is Activate
Re: $$Excel-Macros$$ List Box Like Tally Software
Dear Maries SAM Abi Here with Attached List Box like tally .xlxm what i expected it comes almost 90% which i attached only thing its take time E1 cell activate then my Listbox screen open Left cornor of window Point No. 2 This list Box should come Under Mydata E1 cell then , Listbox should Resize based on My My Item add this should be appear in window screen . Point No. 3 if i have large data base it will take so much time plese sugguest to me or modify my code once i type text box it wil come fast Pl Advice me Thanks for support Regards Chandru On Wed, Feb 22, 2012 at 12:13 AM, chandra sekaran duraichan...@gmail.comwrote: Dear Maries SAM Lot of Thanks Providing such a wonderful coding part, i understand form you, Once again Thanking all Have a Good day for you Regards chandru On Wed, Feb 22, 2012 at 12:05 AM, Maries talk2mar...@gmail.com wrote: Making Combo Box: http://www.screencast.com/t/69UdkpgmFv On Tue, Feb 21, 2012 at 10:34 PM, Maries talk2mar...@gmail.com wrote: Hi Chandru, If you want list box, only two option in Excel like Data Validation, Combo Box. But both options, after selection only data will apply in cell value. Hence, there is no chance compare with database when typing or partial string. I hope this clarify clear. Dear Group Friends, If you have any more ideas, Please share with us. Regards, MARIES. On Tue, Feb 21, 2012 at 10:11 PM, Sam Mathai Chacko samde...@gmail.comwrote: Boss, if you type L, all the customers starting with L is listed in the table below. Then why do you need a separate list in D1? On Tue, Feb 21, 2012 at 11:37 PM, chandra sekaran duraichan...@gmail.com wrote: hi Sam, when i type D1 cell customer name below data coming very perfect but if type D1 cell fist i donot know the Customer name when i D1 Cell Activate then list of Customer name populate after that if type first letter like L then in my Customer list start with L will shown like that it ready reference with Tally List Box sheet pl Regards chandru On Tue, Feb 21, 2012 at 11:31 PM, Sam Mathai Chacko samde...@gmail.com wrote: Use this in Cell A5 and drag down and across =IFERROR(INDEX(Data!A$3:A$82,SMALL(IF(LEFT(Data!$E$3:$E$82,LEN(MyOutput!$D$1))=MyOutput!$D$1,ROW(INDIRECT((1:ROWS(Data!$E$3:$E$82,),ROW()-ROW(MyOutput!A$4))),) Regards, Sam Mathai Chacko On Tue, Feb 21, 2012 at 8:17 PM, chandra sekaran duraichan...@gmail.com wrote: hi exell famly can any one give my logic code if possible, please... chandru On Mon, Feb 20, 2012 at 10:18 PM, chandra sekaran duraichan...@gmail.com wrote: Dear Maries , First of i would thanks for valuable effort , but what i expected like this only if Activate D1 Cell then Immdiataly like below Unique Customer will shown below on the D1 Cell , than i Enter Lletter than Start with L only Bold selected like that . *Cutomer Name* Lotus ABC COMPAY Adako TarimForward InternationalHAND ASSO*LOTUS 123 PVT* ***LOTUS PVT* ** MURUGA COPANY LTDReckitt BenckiserSCJ ArgentinaVAPCO XYZ LTD Thanks for your help Regards chandru On Mon, Feb 20, 2012 at 8:28 PM, Maries talk2mar...@gmail.comwrote: Hi, I got your logic. Check the attachment. Type your text in cell D1 Enter. It will give answer. Regards, MARIES. On Mon, Feb 20, 2012 at 4:39 PM, chandra sekaran duraichan...@gmail.com wrote: Hi maries, thanks for your Reply, MyOutput Sheet D1 Activate then My List of Cutomer may shwon seperate list box or Below D1 Cell there itself we want to select or like sheet Name Tally List box like that if possible [ First time i do not know what are the customer are there in my Data so once D1 is Activate Unique My Cutomer will display if possible please Regards chandru On Mon, Feb 20, 2012 at 5:54 PM, Maries talk2mar...@gmail.comwrote: Hi, Find the attached file. If you type first name in search cell, respective datas will show below. Regards, MARIES. On Mon, Feb 20, 2012 at 2:03 PM, chandra sekaran duraichan...@gmail.com wrote: Dear all Here with attached List Box like Tally is this possible with excelonce Active List box or Cell shown under all name after enter first letter than showing start with all names like that Advance Thanks for all Regards chandru -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums
Re: $$Excel-Macros$$ List Box Like Tally Software
hi exell famly can any one give my logic code if possible, please... chandru On Mon, Feb 20, 2012 at 10:18 PM, chandra sekaran duraichan...@gmail.comwrote: Dear Maries , First of i would thanks for valuable effort , but what i expected like this only if Activate D1 Cell then Immdiataly like below Unique Customer will shown below on the D1 Cell , than i Enter Lletter than Start with L only Bold selected like that . *Cutomer Name* Lotus ABC COMPAY Adako TarimForward InternationalHAND ASSO*LOTUS 123 PVT* ***LOTUS PVT* **MURUGA COPANY LTDReckitt BenckiserSCJ ArgentinaVAPCO XYZ LTD Thanks for your help Regards chandru On Mon, Feb 20, 2012 at 8:28 PM, Maries talk2mar...@gmail.com wrote: Hi, I got your logic. Check the attachment. Type your text in cell D1 Enter. It will give answer. Regards, MARIES. On Mon, Feb 20, 2012 at 4:39 PM, chandra sekaran duraichan...@gmail.comwrote: Hi maries, thanks for your Reply, MyOutput Sheet D1 Activate then My List of Cutomer may shwon seperate list box or Below D1 Cell there itself we want to select or like sheet Name Tally List box like that if possible [ First time i do not know what are the customer are there in my Data so once D1 is Activate Unique My Cutomer will display if possible please Regards chandru On Mon, Feb 20, 2012 at 5:54 PM, Maries talk2mar...@gmail.com wrote: Hi, Find the attached file. If you type first name in search cell, respective datas will show below. Regards, MARIES. On Mon, Feb 20, 2012 at 2:03 PM, chandra sekaran duraichan...@gmail.com wrote: Dear all Here with attached List Box like Tally is this possible with excelonce Active List box or Cell shown under all name after enter first letter than showing start with all names like that Advance Thanks for all Regards chandru -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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
Re: $$Excel-Macros$$ List Box Like Tally Software
hi Sam, when i type D1 cell customer name below data coming very perfect but if type D1 cell fist i donot know the Customer name when i D1 Cell Activate then list of Customer name populate after that if type first letter like L then in my Customer list start with L will shown like that it ready reference with Tally List Box sheet pl Regards chandru On Tue, Feb 21, 2012 at 11:31 PM, Sam Mathai Chacko samde...@gmail.comwrote: Use this in Cell A5 and drag down and across =IFERROR(INDEX(Data!A$3:A$82,SMALL(IF(LEFT(Data!$E$3:$E$82,LEN(MyOutput!$D$1))=MyOutput!$D$1,ROW(INDIRECT((1:ROWS(Data!$E$3:$E$82,),ROW()-ROW(MyOutput!A$4))),) Regards, Sam Mathai Chacko On Tue, Feb 21, 2012 at 8:17 PM, chandra sekaran duraichan...@gmail.comwrote: hi exell famly can any one give my logic code if possible, please... chandru On Mon, Feb 20, 2012 at 10:18 PM, chandra sekaran duraichan...@gmail.com wrote: Dear Maries , First of i would thanks for valuable effort , but what i expected like this only if Activate D1 Cell then Immdiataly like below Unique Customer will shown below on the D1 Cell , than i Enter Lletter than Start with L only Bold selected like that . *Cutomer Name* Lotus ABC COMPAY Adako TarimForward InternationalHAND ASSO*LOTUS 123 PVT* ***LOTUS PVT* **MURUGA COPANY LTDReckitt BenckiserSCJ ArgentinaVAPCO XYZ LTD Thanks for your help Regards chandru On Mon, Feb 20, 2012 at 8:28 PM, Maries talk2mar...@gmail.com wrote: Hi, I got your logic. Check the attachment. Type your text in cell D1 Enter. It will give answer. Regards, MARIES. On Mon, Feb 20, 2012 at 4:39 PM, chandra sekaran duraichan...@gmail.com wrote: Hi maries, thanks for your Reply, MyOutput Sheet D1 Activate then My List of Cutomer may shwon seperate list box or Below D1 Cell there itself we want to select or like sheet Name Tally List box like that if possible [ First time i do not know what are the customer are there in my Data so once D1 is Activate Unique My Cutomer will display if possible please Regards chandru On Mon, Feb 20, 2012 at 5:54 PM, Maries talk2mar...@gmail.com wrote: Hi, Find the attached file. If you type first name in search cell, respective datas will show below. Regards, MARIES. On Mon, Feb 20, 2012 at 2:03 PM, chandra sekaran duraichan...@gmail.com wrote: Dear all Here with attached List Box like Tally is this possible with excelonce Active List box or Cell shown under all name after enter first letter than showing start with all names like that Advance Thanks for all Regards chandru -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums
Re: $$Excel-Macros$$ List Box Like Tally Software
Boss, if you type L, all the customers starting with L is listed in the table below. Then why do you need a separate list in D1? On Tue, Feb 21, 2012 at 11:37 PM, chandra sekaran duraichan...@gmail.comwrote: hi Sam, when i type D1 cell customer name below data coming very perfect but if type D1 cell fist i donot know the Customer name when i D1 Cell Activate then list of Customer name populate after that if type first letter like L then in my Customer list start with L will shown like that it ready reference with Tally List Box sheet pl Regards chandru On Tue, Feb 21, 2012 at 11:31 PM, Sam Mathai Chacko samde...@gmail.comwrote: Use this in Cell A5 and drag down and across =IFERROR(INDEX(Data!A$3:A$82,SMALL(IF(LEFT(Data!$E$3:$E$82,LEN(MyOutput!$D$1))=MyOutput!$D$1,ROW(INDIRECT((1:ROWS(Data!$E$3:$E$82,),ROW()-ROW(MyOutput!A$4))),) Regards, Sam Mathai Chacko On Tue, Feb 21, 2012 at 8:17 PM, chandra sekaran duraichan...@gmail.comwrote: hi exell famly can any one give my logic code if possible, please... chandru On Mon, Feb 20, 2012 at 10:18 PM, chandra sekaran duraichan...@gmail.com wrote: Dear Maries , First of i would thanks for valuable effort , but what i expected like this only if Activate D1 Cell then Immdiataly like below Unique Customer will shown below on the D1 Cell , than i Enter Lletter than Start with L only Bold selected like that . *Cutomer Name* Lotus ABC COMPAY Adako TarimForward InternationalHAND ASSO*LOTUS 123 PVT* ***LOTUS PVT* ** MURUGA COPANY LTDReckitt BenckiserSCJ ArgentinaVAPCO XYZ LTD Thanks for your help Regards chandru On Mon, Feb 20, 2012 at 8:28 PM, Maries talk2mar...@gmail.com wrote: Hi, I got your logic. Check the attachment. Type your text in cell D1 Enter. It will give answer. Regards, MARIES. On Mon, Feb 20, 2012 at 4:39 PM, chandra sekaran duraichan...@gmail.com wrote: Hi maries, thanks for your Reply, MyOutput Sheet D1 Activate then My List of Cutomer may shwon seperate list box or Below D1 Cell there itself we want to select or like sheet Name Tally List box like that if possible [ First time i do not know what are the customer are there in my Data so once D1 is Activate Unique My Cutomer will display if possible please Regards chandru On Mon, Feb 20, 2012 at 5:54 PM, Maries talk2mar...@gmail.comwrote: Hi, Find the attached file. If you type first name in search cell, respective datas will show below. Regards, MARIES. On Mon, Feb 20, 2012 at 2:03 PM, chandra sekaran duraichan...@gmail.com wrote: Dear all Here with attached List Box like Tally is this possible with excelonce Active List box or Cell shown under all name after enter first letter than showing start with all names like that Advance Thanks for all Regards chandru -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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
Re: $$Excel-Macros$$ List Box Like Tally Software
Hi Chandru, If you want list box, only two option in Excel like Data Validation, Combo Box. But both options, after selection only data will apply in cell value. Hence, there is no chance compare with database when typing or partial string. I hope this clarify clear. Dear Group Friends, If you have any more ideas, Please share with us. Regards, MARIES. On Tue, Feb 21, 2012 at 10:11 PM, Sam Mathai Chacko samde...@gmail.comwrote: Boss, if you type L, all the customers starting with L is listed in the table below. Then why do you need a separate list in D1? On Tue, Feb 21, 2012 at 11:37 PM, chandra sekaran duraichan...@gmail.comwrote: hi Sam, when i type D1 cell customer name below data coming very perfect but if type D1 cell fist i donot know the Customer name when i D1 Cell Activate then list of Customer name populate after that if type first letter like L then in my Customer list start with L will shown like that it ready reference with Tally List Box sheet pl Regards chandru On Tue, Feb 21, 2012 at 11:31 PM, Sam Mathai Chacko samde...@gmail.comwrote: Use this in Cell A5 and drag down and across =IFERROR(INDEX(Data!A$3:A$82,SMALL(IF(LEFT(Data!$E$3:$E$82,LEN(MyOutput!$D$1))=MyOutput!$D$1,ROW(INDIRECT((1:ROWS(Data!$E$3:$E$82,),ROW()-ROW(MyOutput!A$4))),) Regards, Sam Mathai Chacko On Tue, Feb 21, 2012 at 8:17 PM, chandra sekaran duraichan...@gmail.com wrote: hi exell famly can any one give my logic code if possible, please... chandru On Mon, Feb 20, 2012 at 10:18 PM, chandra sekaran duraichan...@gmail.com wrote: Dear Maries , First of i would thanks for valuable effort , but what i expected like this only if Activate D1 Cell then Immdiataly like below Unique Customer will shown below on the D1 Cell , than i Enter Lletter than Start with L only Bold selected like that . *Cutomer Name* Lotus ABC COMPAY Adako TarimForward InternationalHAND ASSO*LOTUS 123 PVT* ***LOTUS PVT* ** MURUGA COPANY LTDReckitt BenckiserSCJ ArgentinaVAPCO XYZ LTD Thanks for your help Regards chandru On Mon, Feb 20, 2012 at 8:28 PM, Maries talk2mar...@gmail.com wrote: Hi, I got your logic. Check the attachment. Type your text in cell D1 Enter. It will give answer. Regards, MARIES. On Mon, Feb 20, 2012 at 4:39 PM, chandra sekaran duraichan...@gmail.com wrote: Hi maries, thanks for your Reply, MyOutput Sheet D1 Activate then My List of Cutomer may shwon seperate list box or Below D1 Cell there itself we want to select or like sheet Name Tally List box like that if possible [ First time i do not know what are the customer are there in my Data so once D1 is Activate Unique My Cutomer will display if possible please Regards chandru On Mon, Feb 20, 2012 at 5:54 PM, Maries talk2mar...@gmail.comwrote: Hi, Find the attached file. If you type first name in search cell, respective datas will show below. Regards, MARIES. On Mon, Feb 20, 2012 at 2:03 PM, chandra sekaran duraichan...@gmail.com wrote: Dear all Here with attached List Box like Tally is this possible with excelonce Active List box or Cell shown under all name after enter first letter than showing start with all names like that Advance Thanks for all Regards chandru -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss.
Re: $$Excel-Macros$$ List Box Like Tally Software
Making Combo Box: http://www.screencast.com/t/69UdkpgmFv On Tue, Feb 21, 2012 at 10:34 PM, Maries talk2mar...@gmail.com wrote: Hi Chandru, If you want list box, only two option in Excel like Data Validation, Combo Box. But both options, after selection only data will apply in cell value. Hence, there is no chance compare with database when typing or partial string. I hope this clarify clear. Dear Group Friends, If you have any more ideas, Please share with us. Regards, MARIES. On Tue, Feb 21, 2012 at 10:11 PM, Sam Mathai Chacko samde...@gmail.comwrote: Boss, if you type L, all the customers starting with L is listed in the table below. Then why do you need a separate list in D1? On Tue, Feb 21, 2012 at 11:37 PM, chandra sekaran duraichan...@gmail.com wrote: hi Sam, when i type D1 cell customer name below data coming very perfect but if type D1 cell fist i donot know the Customer name when i D1 Cell Activate then list of Customer name populate after that if type first letter like L then in my Customer list start with L will shown like that it ready reference with Tally List Box sheet pl Regards chandru On Tue, Feb 21, 2012 at 11:31 PM, Sam Mathai Chacko samde...@gmail.comwrote: Use this in Cell A5 and drag down and across =IFERROR(INDEX(Data!A$3:A$82,SMALL(IF(LEFT(Data!$E$3:$E$82,LEN(MyOutput!$D$1))=MyOutput!$D$1,ROW(INDIRECT((1:ROWS(Data!$E$3:$E$82,),ROW()-ROW(MyOutput!A$4))),) Regards, Sam Mathai Chacko On Tue, Feb 21, 2012 at 8:17 PM, chandra sekaran duraichan...@gmail.com wrote: hi exell famly can any one give my logic code if possible, please... chandru On Mon, Feb 20, 2012 at 10:18 PM, chandra sekaran duraichan...@gmail.com wrote: Dear Maries , First of i would thanks for valuable effort , but what i expected like this only if Activate D1 Cell then Immdiataly like below Unique Customer will shown below on the D1 Cell , than i Enter Lletter than Start with L only Bold selected like that . *Cutomer Name* Lotus ABC COMPAY Adako TarimForward InternationalHAND ASSO*LOTUS 123 PVT* ***LOTUS PVT* ** MURUGA COPANY LTDReckitt BenckiserSCJ ArgentinaVAPCO XYZ LTD Thanks for your help Regards chandru On Mon, Feb 20, 2012 at 8:28 PM, Maries talk2mar...@gmail.comwrote: Hi, I got your logic. Check the attachment. Type your text in cell D1 Enter. It will give answer. Regards, MARIES. On Mon, Feb 20, 2012 at 4:39 PM, chandra sekaran duraichan...@gmail.com wrote: Hi maries, thanks for your Reply, MyOutput Sheet D1 Activate then My List of Cutomer may shwon seperate list box or Below D1 Cell there itself we want to select or like sheet Name Tally List box like that if possible [ First time i do not know what are the customer are there in my Data so once D1 is Activate Unique My Cutomer will display if possible please Regards chandru On Mon, Feb 20, 2012 at 5:54 PM, Maries talk2mar...@gmail.comwrote: Hi, Find the attached file. If you type first name in search cell, respective datas will show below. Regards, MARIES. On Mon, Feb 20, 2012 at 2:03 PM, chandra sekaran duraichan...@gmail.com wrote: Dear all Here with attached List Box like Tally is this possible with excelonce Active List box or Cell shown under all name after enter first letter than showing start with all names like that Advance Thanks for all Regards chandru -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are
Re: $$Excel-Macros$$ List Box Like Tally Software
Dear Maries SAM Lot of Thanks Providing such a wonderful coding part, i understand form you, Once again Thanking all Have a Good day for you Regards chandru On Wed, Feb 22, 2012 at 12:05 AM, Maries talk2mar...@gmail.com wrote: Making Combo Box: http://www.screencast.com/t/69UdkpgmFv On Tue, Feb 21, 2012 at 10:34 PM, Maries talk2mar...@gmail.com wrote: Hi Chandru, If you want list box, only two option in Excel like Data Validation, Combo Box. But both options, after selection only data will apply in cell value. Hence, there is no chance compare with database when typing or partial string. I hope this clarify clear. Dear Group Friends, If you have any more ideas, Please share with us. Regards, MARIES. On Tue, Feb 21, 2012 at 10:11 PM, Sam Mathai Chacko samde...@gmail.comwrote: Boss, if you type L, all the customers starting with L is listed in the table below. Then why do you need a separate list in D1? On Tue, Feb 21, 2012 at 11:37 PM, chandra sekaran duraichan...@gmail.com wrote: hi Sam, when i type D1 cell customer name below data coming very perfect but if type D1 cell fist i donot know the Customer name when i D1 Cell Activate then list of Customer name populate after that if type first letter like L then in my Customer list start with L will shown like that it ready reference with Tally List Box sheet pl Regards chandru On Tue, Feb 21, 2012 at 11:31 PM, Sam Mathai Chacko samde...@gmail.com wrote: Use this in Cell A5 and drag down and across =IFERROR(INDEX(Data!A$3:A$82,SMALL(IF(LEFT(Data!$E$3:$E$82,LEN(MyOutput!$D$1))=MyOutput!$D$1,ROW(INDIRECT((1:ROWS(Data!$E$3:$E$82,),ROW()-ROW(MyOutput!A$4))),) Regards, Sam Mathai Chacko On Tue, Feb 21, 2012 at 8:17 PM, chandra sekaran duraichan...@gmail.com wrote: hi exell famly can any one give my logic code if possible, please... chandru On Mon, Feb 20, 2012 at 10:18 PM, chandra sekaran duraichan...@gmail.com wrote: Dear Maries , First of i would thanks for valuable effort , but what i expected like this only if Activate D1 Cell then Immdiataly like below Unique Customer will shown below on the D1 Cell , than i Enter Lletter than Start with L only Bold selected like that . *Cutomer Name* Lotus ABC COMPAY Adako TarimForward InternationalHAND ASSO*LOTUS 123 PVT* ***LOTUS PVT* ** MURUGA COPANY LTDReckitt BenckiserSCJ ArgentinaVAPCO XYZ LTD Thanks for your help Regards chandru On Mon, Feb 20, 2012 at 8:28 PM, Maries talk2mar...@gmail.comwrote: Hi, I got your logic. Check the attachment. Type your text in cell D1 Enter. It will give answer. Regards, MARIES. On Mon, Feb 20, 2012 at 4:39 PM, chandra sekaran duraichan...@gmail.com wrote: Hi maries, thanks for your Reply, MyOutput Sheet D1 Activate then My List of Cutomer may shwon seperate list box or Below D1 Cell there itself we want to select or like sheet Name Tally List box like that if possible [ First time i do not know what are the customer are there in my Data so once D1 is Activate Unique My Cutomer will display if possible please Regards chandru On Mon, Feb 20, 2012 at 5:54 PM, Maries talk2mar...@gmail.comwrote: Hi, Find the attached file. If you type first name in search cell, respective datas will show below. Regards, MARIES. On Mon, Feb 20, 2012 at 2:03 PM, chandra sekaran duraichan...@gmail.com wrote: Dear all Here with attached List Box like Tally is this possible with excelonce Active List box or Cell shown under all name after enter first letter than showing start with all names like that Advance Thanks for all Regards chandru -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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
Re: $$Excel-Macros$$ List Box Like Tally Software
Hi maries, thanks for your Reply, MyOutput Sheet D1 Activate then My List of Cutomer may shwon seperate list box or Below D1 Cell there itself we want to select or like sheet Name Tally List box like that if possible [ First time i do not know what are the customer are there in my Data so once D1 is Activate Unique My Cutomer will display if possible please Regards chandru On Mon, Feb 20, 2012 at 5:54 PM, Maries talk2mar...@gmail.com wrote: Hi, Find the attached file. If you type first name in search cell, respective datas will show below. Regards, MARIES. On Mon, Feb 20, 2012 at 2:03 PM, chandra sekaran duraichan...@gmail.comwrote: Dear all Here with attached List Box like Tally is this possible with excel once Active List box or Cell shown under all name after enter first letter than showing start with all names like that Advance Thanks for all Regards chandru -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ List Box Like Tally Software
Dear Maries , First of i would thanks for valuable effort , but what i expected like this only if Activate D1 Cell then Immdiataly like below Unique Customer will shown below on the D1 Cell , than i Enter Lletter than Start with L only Bold selected like that . *Cutomer Name* Lotus ABC COMPAY Adako TarimForward InternationalHAND ASSO*LOTUS 123 PVT* ***LOTUS PVT* **MURUGA COPANY LTDReckitt BenckiserSCJ ArgentinaVAPCO XYZ LTD Thanks for your help Regards chandru On Mon, Feb 20, 2012 at 8:28 PM, Maries talk2mar...@gmail.com wrote: Hi, I got your logic. Check the attachment. Type your text in cell D1 Enter. It will give answer. Regards, MARIES. On Mon, Feb 20, 2012 at 4:39 PM, chandra sekaran duraichan...@gmail.comwrote: Hi maries, thanks for your Reply, MyOutput Sheet D1 Activate then My List of Cutomer may shwon seperate list box or Below D1 Cell there itself we want to select or like sheet Name Tally List box like that if possible [ First time i do not know what are the customer are there in my Data so once D1 is Activate Unique My Cutomer will display if possible please Regards chandru On Mon, Feb 20, 2012 at 5:54 PM, Maries talk2mar...@gmail.com wrote: Hi, Find the attached file. If you type first name in search cell, respective datas will show below. Regards, MARIES. On Mon, Feb 20, 2012 at 2:03 PM, chandra sekaran duraichan...@gmail.com wrote: Dear all Here with attached List Box like Tally is this possible with excelonce Active List box or Cell shown under all name after enter first letter than showing start with all names like that Advance Thanks for all Regards chandru -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential
Re: $$Excel-Macros$$ List Box or copy past Shwon based on typing leter
Hi Shaik, Check this link... http://www.screencast.com/t/69UdkpgmFv Regards, MARIES. On Thu, Feb 16, 2012 at 3:05 PM, Shaik Waheed waheedb...@gmail.com wrote: Hi Maries, Can u tell me how did u do that.. On Thu, Feb 16, 2012 at 3:25 PM, Maries talk2mar...@gmail.com wrote: Find the attachments.. On Thu, Feb 16, 2012 at 1:35 PM, chandra sekaran duraichan...@gmail.comwrote: Hi , Here with attchaed file we need smal macro when i type first Letter than shown start with first if type second letter then based on my cretria shown all list can any one help me Like i have name list example Name Moahn Mohan Kumar Mohan Doss Mathan Mathan Kumar Ashok ashok sing Ashok Kumar Ashish Kisan IF I ENTER CELL D2M then shown all my name list start with M then i type Mo THEN THEN ONLY Star with Mo like that Advance thanks for all Regards chandru -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ List Box or copy past Shwon based on typing leter
Hi Maries, Thats really great..Thank you.. On Fri, Feb 17, 2012 at 3:10 PM, Maries talk2mar...@gmail.com wrote: Hi Shaik, Check this link... http://www.screencast.com/t/69UdkpgmFv Regards, MARIES. On Thu, Feb 16, 2012 at 3:05 PM, Shaik Waheed waheedb...@gmail.comwrote: Hi Maries, Can u tell me how did u do that.. On Thu, Feb 16, 2012 at 3:25 PM, Maries talk2mar...@gmail.com wrote: Find the attachments.. On Thu, Feb 16, 2012 at 1:35 PM, chandra sekaran duraichan...@gmail.com wrote: Hi , Here with attchaed file we need smal macro when i type first Letter than shown start with first if type second letter then based on my cretria shown all list can any one help me Like i have name list example Name Moahn Mohan Kumar Mohan Doss Mathan Mathan Kumar Ashok ashok sing Ashok Kumar Ashish Kisan IF I ENTER CELL D2M then shown all my name list start with M then i type Mo THEN THEN ONLY Star with Mo like that Advance thanks for all Regards chandru -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of,
Re: $$Excel-Macros$$ List Box or copy past Shwon based on typing leter
Maries, That was awesome!! I was asking myself what if there is a need to expand the range? So I am wondering if using a range name will do the trick i.e update the range : Formulaname manager ( I am using excel 2010).I've tried it but it didn't work. Please advise. Regards On Feb 17, 5:39 am, Shaik Waheed waheedb...@gmail.com wrote: Hi Maries, Thats really great..Thank you.. On Fri, Feb 17, 2012 at 3:10 PM, Maries talk2mar...@gmail.com wrote: Hi Shaik, Check this link... http://www.screencast.com/t/69UdkpgmFv Regards, MARIES. On Thu, Feb 16, 2012 at 3:05 PM, Shaik Waheed waheedb...@gmail.comwrote: Hi Maries, Can u tell me how did u do that.. On Thu, Feb 16, 2012 at 3:25 PM, Maries talk2mar...@gmail.com wrote: Find the attachments.. On Thu, Feb 16, 2012 at 1:35 PM, chandra sekaran duraichan...@gmail.com wrote: Hi , Here with attchaed file we need smal macro when i type first Letter than shown start with first if type second letter then based on my cretria shown all list can any one help me Like i have name list example Name Moahn Mohan Kumar Mohan Doss Mathan Mathan Kumar Ashok ashok sing Ashok Kumar Ashish Kisan IF I ENTER CELL D2 M then shown all my name list start with M then i type Mo THEN THEN ONLY Star with Mo like that Advance thanks for all Regards chandru -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- --- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- --- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- --- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- --- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for
Re: $$Excel-Macros$$ List Box or copy past Shwon based on typing leter
Find the attachments.. On Thu, Feb 16, 2012 at 1:35 PM, chandra sekaran duraichan...@gmail.comwrote: Hi , Here with attchaed file we need smal macro when i type first Letter than shown start with first if type second letter then based on my cretria shown all list can any one help me Like i have name list example Name Moahn Mohan Kumar Mohan Doss Mathan Mathan Kumar Ashok ashok sing Ashok Kumar Ashish Kisan IF I ENTER CELL D2M then shown all my name list start with M then i type Mo THEN THEN ONLY Star with Mo like that Advance thanks for all Regards chandru -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com List Box.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ List Box or copy past Shwon based on typing leter
Hi Maries, Can u tell me how did u do that.. On Thu, Feb 16, 2012 at 3:25 PM, Maries talk2mar...@gmail.com wrote: Find the attachments.. On Thu, Feb 16, 2012 at 1:35 PM, chandra sekaran duraichan...@gmail.comwrote: Hi , Here with attchaed file we need smal macro when i type first Letter than shown start with first if type second letter then based on my cretria shown all list can any one help me Like i have name list example Name Moahn Mohan Kumar Mohan Doss Mathan Mathan Kumar Ashok ashok sing Ashok Kumar Ashish Kisan IF I ENTER CELL D2M then shown all my name list start with M then i type Mo THEN THEN ONLY Star with Mo like that Advance thanks for all Regards chandru -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
RE: $$Excel-Macros$$ List Box
Works for me. Put a break point onto the last line and check the array data. Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Richard Envoyé : lundi 13 juin 2011 22:14 À : excel-macros@googlegroups.com Objet : $$Excel-Macros$$ List Box I am trying to populate a list box with the results of a query. I have created the following code, which only populates the first column of a two column listbox. The items in MyArray are present for both bolumns. Dim MyArray() ReDim MyArray(mycount, 1) usrGLDist.lstOutput.ColumnCount = 2 For i = 0 To rst.Count - 1 MyArray(i, 0) = rst.Value(descr) MyArray(i, 1) = rst.Value(pcamt) rst.MoveNext Next i usrGLDist.lstOutput.List() = MyArray Thanks in advance for any help. Rich -- -- 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 http://exceldailytip.blogspot.com To post to this group, send email to mailto:excel-macros@googlegroups.com excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel 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
Re: $$Excel-Macros$$ List Box
It's been a while since I've done it, so I would have to locate an old file, or create it from scratch, but basically: You loop through the items in the list and check the selected property (I think) of each item. Paul - Original Message From: Nush nus...@googlemail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Thu, January 14, 2010 9:21:22 AM Subject: $$Excel-Macros$$ List Box Hi, I want to create a macro based on a number of selections from a listbox. I know that with 'single selection' you can return the number of the item using 'cell link' but I would like to be able to select a number of items and return their respective codes? Essentially I want to create a macro which enables me to select charts within a workbook and then copy them into a word doc Thanks -- -- Some important links for excel users: 1. Follow us in TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us in TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe