*Done SAM*, wonderful thanks for your cooperation. I think I must have to save this add in file in save location for permanent use of this function is it? second this add in don't show in ribbon no problem but I saw that my friend create the add in and it shows in the ribbon with his multi commands can I use this in the ribbon with button.
And can I create further macros solutions in the same add in with multi buttons? Thanks again for your cooperate. Regards, Aamir Shahzad On Thu, Oct 27, 2011 at 1:38 AM, Sam Mathai Chacko <samde...@gmail.com>wrote: > 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 > -- 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
