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
