Aamir, I was just checking, and found that I was wrong. You have to save a file as an add-in for this to work. Create a new file, put the code in a new module of that file, and save it as add-in (.xlam).
Sam On Thu, Oct 27, 2011 at 1:19 AM, Aamir Shahzad <aamirshahza...@gmail.com>wrote: > I am pasting SAM see attached file may be doing some thing wrong. In your > previous mail you instructed to create xlsb file why? > > > On Thu, Oct 27, 2011 at 12:44 AM, Sam Mathai Chacko <samde...@gmail.com>wrote: > >> Aamir, you have to past the code in the code module, not the >> workbook/sheet module >> >> Sam >> >> >> On Thu, Oct 27, 2011 at 1:12 AM, Aamir Shahzad >> <aamirshahza...@gmail.com>wrote: >> >>> SAM - I am doing your instruction like this: >>> 1) In the blank new work book opening marco by shortkey. >>> 2) selecting personal workbook. Click ok >>> 3) then going to VBE window. In the Personal Macro workbook & in the >>> module after pasting your code then save then close. >>> 4) after that in excel typing the required multiresultlookedup formula >>> still not showing >>> what I am doing wrong. Please help. >>> >>> Aamir Shahzad >>> >>> >>> On Tue, Oct 25, 2011 at 1:37 AM, Sam Mathai Chacko >>> <samde...@gmail.com>wrote: >>> >>>> OK. Click on record macro from the developer tab. Short cut key >>>> ALT+T+M+R >>>> >>>> Then in the option to select store macro in, select personal workbook. >>>> Then click OK. Then do anything on the spreadsheet, like select a cell, or >>>> delete a row or something. The stop the macro recording. You can use the >>>> same short cut key as above. >>>> >>>> Then click ALT+F11. This will take you to the VBE window. There in the >>>> project explorer window you will see the personal macro workbook. In that >>>> you will find a module. In the module, just paste my code, and then use it >>>> like you would normally use any formula.. >>>> >>>> Regards, >>>> >>>> Sam >>>> >>>> >>>> On Tue, Oct 25, 2011 at 1:50 AM, Aamir Shahzad < >>>> aamirshahza...@gmail.com> wrote: >>>> >>>>> SAM please further brief step by step procedure which are you saying as >>>>> I am very new in macro. >>>>> >>>>> Aamir Shahzad >>>>> >>>>> On Tue, Oct 25, 2011 at 1:05 AM, Sam Mathai Chacko <samde...@gmail.com >>>>> > wrote: >>>>> >>>>>> Aamir, copy the entire code to your personal.xlsb file. You will now >>>>>> have it available in all your workbooks, similar to an add-in. >>>>>> >>>>>> If you do not have the personal file, just do any macro recording by >>>>>> selecting the personal workbook. Stop recording, and the overwrite the >>>>>> macro >>>>>> that was recorded. >>>>>> >>>>>> >>>>>> Regards, >>>>>> >>>>>> Sam Mathai Chacko (GL) >>>>>> >>>>>> On Tue, Oct 25, 2011 at 1:32 AM, Aamir Shahzad < >>>>>> aamirshahza...@gmail.com> wrote: >>>>>> >>>>>>> thank you very much SAM for this wonderful solution. But I want to >>>>>>> make this to permanent function you can say by means of add in, I want >>>>>>> to >>>>>>> make add in to use this "MultiResultLookedup" Macro because any time if >>>>>>> I >>>>>>> want to use this function I have to convert the file format xlsx to >>>>>>> xlsm. >>>>>>> Please suggest. >>>>>>> >>>>>>> Regards, >>>>>>> >>>>>>> Aamir Shahzad >>>>>>> >>>>>>> On Mon, Oct 24, 2011 at 10:27 PM, Sam Mathai Chacko < >>>>>>> samde...@gmail.com> wrote: >>>>>>> >>>>>>>> Function MultiResultLookedUp(varLookupValue, rngRange As Range) As >>>>>>>> String >>>>>>>> >>>>>>>> Dim lngLoop As Long >>>>>>>> Dim varArray >>>>>>>> varArray = rngRange >>>>>>>> >>>>>>>> For lngLoop = LBound(varArray, 1) To UBound(varArray, 1) >>>>>>>> If varArray(lngLoop, 1) = varLookupValue Then >>>>>>>> MultiResultLookedUp = MultiResultLookedUp & >>>>>>>> varArray(lngLoop, 2) & "/" >>>>>>>> End If >>>>>>>> Next lngLoop >>>>>>>> MultiResultLookedUp = Left(MultiResultLookedUp, >>>>>>>> Len(MultiResultLookedUp) - 1) >>>>>>>> >>>>>>>> End Function >>>>>>>> >>>>>>>> >>>>>>>> Regards, >>>>>>>> >>>>>>>> Sam Mathai Chacko (GL) >>>>>>>> >>>>>>>> >>>>>>>> On Mon, Oct 24, 2011 at 10:46 PM, Aamir Shahzad < >>>>>>>> aamirshahza...@gmail.com> wrote: >>>>>>>> >>>>>>>>> Dear Experts, >>>>>>>>> >>>>>>>>> I want to pick the multi values like vlookup formula. Is there any >>>>>>>>> way? Sheet attached. Can we prepare the any function e.g. (mylookup) >>>>>>>>> which >>>>>>>>> save in excel & when ever I use that function it picks the desired >>>>>>>>> values >>>>>>>>> like attached sheet. >>>>>>>>> >>>>>>>>> Regards, >>>>>>>>> >>>>>>>>> Aamir Shahzad >>>>>>>>> -- >>>>>>>>> >>>>>>>>> ---------------------------------------------------------------------------------- >>>>>>>>> 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 >>>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> -- >>>>>>>> Sam Mathai Chacko >>>>>>>> >>>>>>>> -- >>>>>>>> >>>>>>>> ---------------------------------------------------------------------------------- >>>>>>>> Some important links for excel users: >>>>>>>> 1. Follow us on TWITTER for tips tricks and links : >>>>>>>> http://twitter.com/exceldailytip >>>>>>>> 2. Join our LinkedIN group @ >>>>>>>> http://www.linkedin.com/groups?gid=1871310 >>>>>>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>>>>>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>>>>>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>>>>>>> >>>>>>>> To post to this group, send email to excel-macros@googlegroups.com >>>>>>>> >>>>>>>> <><><><><><><><><><><><><><><><><><><><><><> >>>>>>>> Like our page on facebook , Just follow below link >>>>>>>> http://www.facebook.com/discussexcel >>>>>>>> >>>>>>> >>>>>>> -- >>>>>>> >>>>>>> ---------------------------------------------------------------------------------- >>>>>>> Some important links for excel users: >>>>>>> 1. Follow us on TWITTER for tips tricks and links : >>>>>>> http://twitter.com/exceldailytip >>>>>>> 2. Join our LinkedIN group @ >>>>>>> http://www.linkedin.com/groups?gid=1871310 >>>>>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>>>>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>>>>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>>>>>> >>>>>>> To post to this group, send email to excel-macros@googlegroups.com >>>>>>> >>>>>>> <><><><><><><><><><><><><><><><><><><><><><> >>>>>>> Like our page on facebook , Just follow below link >>>>>>> http://www.facebook.com/discussexcel >>>>>>> >>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> Sam Mathai Chacko >>>>>> -- >>>>>> >>>>>> ---------------------------------------------------------------------------------- >>>>>> Some important links for excel users: >>>>>> 1. Follow us on TWITTER for tips tricks and links : >>>>>> http://twitter.com/exceldailytip >>>>>> 2. Join our LinkedIN group @ >>>>>> http://www.linkedin.com/groups?gid=1871310 >>>>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>>>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>>>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>>>>> >>>>>> To post to this group, send email to excel-macros@googlegroups.com >>>>>> >>>>>> <><><><><><><><><><><><><><><><><><><><><><> >>>>>> Like our page on facebook , Just follow below link >>>>>> http://www.facebook.com/discussexcel >>>>>> >>>>> >>>>> -- >>>>> >>>>> ---------------------------------------------------------------------------------- >>>>> Some important links for excel users: >>>>> 1. Follow us on TWITTER for tips tricks and links : >>>>> http://twitter.com/exceldailytip >>>>> 2. Join our LinkedIN group @ >>>>> http://www.linkedin.com/groups?gid=1871310 >>>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>>>> >>>>> To post to this group, send email to excel-macros@googlegroups.com >>>>> >>>>> <><><><><><><><><><><><><><><><><><><><><><> >>>>> Like our page on facebook , Just follow below link >>>>> http://www.facebook.com/discussexcel >>>>> >>>> >>>> >>>> >>>> -- >>>> Sam Mathai Chacko >>>> -- >>>> >>>> ---------------------------------------------------------------------------------- >>>> Some important links for excel users: >>>> 1. Follow us on TWITTER for tips tricks and links : >>>> http://twitter.com/exceldailytip >>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>>> >>>> To post to this group, send email to excel-macros@googlegroups.com >>>> >>>> <><><><><><><><><><><><><><><><><><><><><><> >>>> Like our page on facebook , Just follow below link >>>> http://www.facebook.com/discussexcel >>>> >>> >>> -- >>> >>> ---------------------------------------------------------------------------------- >>> Some important links for excel users: >>> 1. Follow us on TWITTER for tips tricks and links : >>> http://twitter.com/exceldailytip >>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>> >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> <><><><><><><><><><><><><><><><><><><><><><> >>> Like our page on facebook , Just follow below link >>> http://www.facebook.com/discussexcel >>> >> >> >> >> -- >> Sam Mathai Chacko >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- Sam Mathai Chacko -- ---------------------------------------------------------------------------------- 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