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 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 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 -- 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 -- Sam Mathai Chacko -- 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
