No, do not create an xlsb. Create an xlam. The add it to the add-in list. Sam
On Thu, Oct 27, 2011 at 1:51 AM, Aamir Shahzad <aamirshahza...@gmail.com>wrote: > created as xlsb now tell me how to use, I mean how to use now > > Aamir Shahzad > > On Thu, Oct 27, 2011 at 1:08 AM, Sam Mathai Chacko <samde...@gmail.com>wrote: > >> 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 >> > > -- > > ---------------------------------------------------------------------------------- > 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