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