Re: $$Excel-Macros$$ Excel Add-in (that enables Auto-complete)

2017-06-01 Thread Carlisle Flores-Garay
Hi, I see your code and this spread sheet is great. I was wondering if there was a way to stop the code from running when you select the whole row to copy and paste it in a different line. On Thursday, April 25, 2013 at 3:24:17 AM UTC-4, Abhishek Jain wrote: > > Please see the attached. > > F

Re: $$Excel-Macros$$ Excel Add-in (that enables Auto-complete)

2015-04-21 Thread Jeffrey DeAnna
Does this function as an autocomplete for drop down validation lists? I've been looking forever for a solution but I am beginning to lose hope. I need it to function without using combobox. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Joi

Re: $$Excel-Macros$$ excel add-in to .exe

2014-10-13 Thread Paul Schreiner
From: "myxlg...@gmail.com" >To: excel-macros@googlegroups.com >Sent: Saturday, October 11, 2014 9:45 AM >Subject: $$Excel-Macros$$ excel add-in to .exe > > > >Sir, >is it possible to convert add-in (some macros) to .exe file. >if possible pls suggest software

$$Excel-Macros$$ excel add-in to .exe

2014-10-11 Thread myxlguru
Sir, is it possible to convert add-in (some macros) to .exe file. if possible pls suggest software (vb.net or any) & procedure. i checked excel compiler which is free in net but not succeed thanks -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) !

Re: $$Excel-Macros$$ Excel Add-in (that enables Auto-complete)

2014-08-03 Thread Kathy Griffee
I am not the greatest at coding, but this is sheer genius for me. I have gotten it to work in a similar workbook with great results. My question to this old thread is this: I have about 7 different worksheets of lists. List 1 is used to autocomplete cells c7,c18,c19,c25 in the master sheet.

Re: $$Excel-Macros$$ Excel Add-in (that enables Auto-complete)

2014-06-12 Thread Abhishek Jain
Its a name range. See the range under "Name Manager" in the "Formulas" tab (Excel 2007). HTH/Abhishek On Thu, Jun 12, 2014 at 6:29 PM, Waqar Ahmed wrote: > Hello everybody, > > I have a problem that I can't increase the list range , I can't find value > (Range name "List") Please help. > > Reg

Re: $$Excel-Macros$$ Excel Add-in (that enables Auto-complete)

2014-06-12 Thread Waqar Ahmed
Hello everybody, I have a problem that I can't increase the list range , I can't find value (Range name "List") Please help. Regards On Thursday, April 25, 2013 12:54:17 PM UTC+5:30, Abhi wrote: > Please see the attached. > > First sheet (List) has the list of items wherein the VBA would searc

$$Excel-Macros$$ Excel Add in

2014-03-25 Thread Divaker Pandey
Excel (2007) intermittently adds the full pathname of the add-in to the function name when it's used in a cell formula. Then if the spreadsheet is opened on another computer, even if the other computer has the add-in installed, the function is not recognized. Any idea how to solve this? Divaker

Re: $$Excel-Macros$$ Excel Add-in (that enables Auto-complete)

2013-04-24 Thread Mathan
Hi, Can we do this using VBA macro? I understand that excel will struggle while searching. But is it possible? If yes, could anyone help me out? Thanks On Wed, Apr 24, 2013 at 2:45 PM, Kanwaljit Singh wrote: > Hello Sir, > > What I understand that is > --You are using a Validation List > --You

Re: $$Excel-Macros$$ Excel Add-in (that enables Auto-complete)

2013-04-24 Thread Kanwaljit Singh
Hello Sir, What I understand that is --You are using a Validation List --You want that When you start typing in the cell, the entries in validation list start reducing to those matching the words, like a wild-card search. It that is true, I don't think there is any Excel Add-in for such purpose.

Re: $$Excel-Macros$$ Excel Add-in (that enables Auto-complete)

2013-04-24 Thread Mathan
Mathan wrote: > > From: Mathan > Subject: Re: $$Excel-Macros$$ Excel Add-in (that enables Auto-complete) > To: excel-macros@googlegroups.com > Date: Sunday, April 21, 2013, 9:17 PM > > Hi Experts, Any updates on this ? Your help is much appreciated.. Thanks > > > > On S

Re: $$Excel-Macros$$ Excel Add-in (that enables Auto-complete)

2013-04-23 Thread Mathan
e which will replace off into Office >> Supplies. >> >> Just go to file->option->proofing->autocorrect, type off in replace box >> and office Supplies in with box. >> >> --- On *Sun, 4/21/13, Mathan * wrote: >> >> >> From: Mathan >

Re: $$Excel-Macros$$ Excel Add-in (that enables Auto-complete)

2013-04-23 Thread Smitha S R
ice Supplies in with box. > > --- On *Sun, 4/21/13, Mathan * wrote: > > > From: Mathan > > Subject: Re: $$Excel-Macros$$ Excel Add-in (that enables Auto-complete) > To: excel-macros@googlegroups.com > Date: Sunday, April 21, 2013, 9:17 PM > > > Hi Experts,

Re: $$Excel-Macros$$ Excel Add-in (that enables Auto-complete)

2013-04-22 Thread Mathan
Mathan wrote: > > From: Mathan > Subject: Re: $$Excel-Macros$$ Excel Add-in (that enables Auto-complete) > To: excel-macros@googlegroups.com > Date: Sunday, April 21, 2013, 9:17 PM > > Hi Experts, Any updates on this ? Your help is much appreciated.. Thanks > > > > On S

Re: $$Excel-Macros$$ Excel Add-in (that enables Auto-complete)

2013-04-22 Thread ravinder negi
you can use auto corrrect feature which will replace off into Office Supplies. Just go to file->option->proofing->autocorrect, type off in replace box and office Supplies in with box. --- On Sun, 4/21/13, Mathan wrote: From: Mathan Subject: Re: $$Excel-Macros$$ Excel Add-in (that ena

Re: $$Excel-Macros$$ Excel Add-in (that enables Auto-complete)

2013-04-21 Thread regards
: $$Excel-Macros$$ Excel Add-in (that enables Auto-complete) Hi, thanks for your reply but my requirement is different. Auto complete should work even the words are in different column or different sheet. And it's not work with Alt+down arrow. Thanks On 21/04/2013, xlstime wrote: > H

Re: $$Excel-Macros$$ Excel Add-in (that enables Auto-complete)

2013-04-21 Thread Mathan
Hi, thanks for your reply but my requirement is different. Auto complete should work even the words are in different column or different sheet. And it's not work with Alt+down arrow. Thanks On 21/04/2013, xlstime wrote: > Hi Mathan, > > You can use "Pick from drop-down list" > > just press Alt+d

Re: $$Excel-Macros$$ Excel Add-in (that enables Auto-complete)

2013-04-21 Thread xlstime
Hi Mathan, You can use "Pick from drop-down list" just press Alt+down arrow . Enjoy Team XLS On Sun, Apr 21, 2013 at 9:17 PM, Mathan wrote: > Hi Experts, Any updates on this ? Your help is much appreciated.. Thanks > > > On Sat, Apr 13, 2013 at 12:32 AM, Mathan w

Re: $$Excel-Macros$$ Excel Add-in (that enables Auto-complete)

2013-04-21 Thread Mathan
Hi Experts, Any updates on this ? Your help is much appreciated.. Thanks On Sat, Apr 13, 2013 at 12:32 AM, Mathan wrote: > Hello Experts, > > I am looking for an excel add-in that will enable Autocomplete from any > column or Sheet within a workbook > > For example, lets say i have a sheet call

$$Excel-Macros$$ Excel Add-in (that enables Auto-complete)

2013-04-12 Thread Mathan
Hello Experts, I am looking for an excel add-in that will enable Autocomplete from any column or Sheet within a workbook For example, lets say i have a sheet called "Accounts" where I have the following: A1 - Office Supplies A2 - Marketing A3 - Auto Expense A4 - Payroll If I go to *A5* and sta

Re: $$Excel-Macros$$ EXCEL ADD-IN for reconciling two Data Tables

2012-09-15 Thread SAGAR KASANGOTTUWAR
ards* >> >> *Rajan verma* >> >> *+91 7838100659 [IM-Gtalk]* >> >> * * >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *On Behalf Of *Aju Chacko >> *Sent:* 13 September 2012 11:

Re: $$Excel-Macros$$ EXCEL ADD-IN for reconciling two Data Tables

2012-09-14 Thread Ashish Bhalara
gt; excel-macros@googlegroups.com] *On Behalf Of *Aju Chacko > *Sent:* 13 September 2012 11:59 > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ EXCEL ADD-IN for reconciling two Data Tables** > ** > > ** ** > > Dear Friends, > Please

RE: $$Excel-Macros$$ EXCEL ADD-IN for reconciling two Data Tables

2012-09-14 Thread Rajan_Verma
Its Wow J Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Aju Chacko Sent: 13 September 2012 11:59 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ EXCEL ADD-IN for reconciling two Data

$$Excel-Macros$$ Excel Add-In or XLSTART file not working

2011-12-18 Thread Fin
I am very new to Excel VBA Code so please forgive my coding clumsiness. I have the following Code that I use to format various reports. I want to be able to install it automatically for CSV files I open, format then save as xls files. I have tried creating both an xla add-in file and when that

$$Excel-Macros$$ Excel add-in and Reference in VBA

2009-06-15 Thread zheng yu
Hi All, Can anybody tell the difference between add-in in sheet and reference in VBA? cheers Vincet --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and