I have done as said still the function is not working. So i want to know where am i going wrong?
I have send u the screen shots on ur email as i dont know how to attach files on these grp Thanks, Karan On Dec 2, 8:15 pm, Sam Mathai Chacko <samde...@gmail.com> wrote: > Karan, sure I will try to help, but what is the problem to start with? You > haven't mentioned what issue you are facing. > > Sam > > > > > > > > On Fri, Dec 2, 2011 at 12:26 PM, Karan <karanscorp...@gmail.com> wrote: > > Dear SAM, > > > I have created the addin from the above trailing mails. Can u please > > guide me where am i going wrong or how to use it once the addin is > > created? > > > Please help > > > On Oct 27, 1:59 am, Aamir Shahzad <aamirshahza...@gmail.com> wrote: > > > *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 athttp://www.excel-macros.blogspot.com > > > >>>>>>>>>>>> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > > >>>>>>>>>>>> 5. Excel Tips and Tricks athttp:// > > 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 athttp://www.excel-macros.blogspot.com > > > >>>>>>>>>>> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > > >>>>>>>>>>> 5. Excel Tips and Tricks athttp://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 athttp://www.excel-macros.blogspot.com > > > >>>>>>>>>> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > > >>>>>>>>>> 5. Excel Tips and Tricks athttp://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 athttp://www.excel-macros.blogspot.com > > > >>>>>>>>> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > > >>>>>>>>> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > ... > > read more » -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
