Fwd: $$Excel-Macros$$ Conditional calculation required for multiple criteria.

2016-10-14 Thread Dheeraj Bankoti
Hi Can any expert resolve the query.. Regards -- Forwarded message -- From: Dheeraj Bankoti Date: Sun, Oct 9, 2016 at 1:24 PM Subject: Fwd: $$Excel-Macros$$ Conditional calculation required for multiple criteria. To: excel-macros@googlegroups.com

Re: $$Excel-Macros$$ MACRO NOT WORKNIG

2016-10-14 Thread GENIUS
Thank you very much Mr. Mihai Ghilea -- 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) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles,

Re: $$Excel-Macros$$ Show listbox for user to click check boxes while macro is running

2016-10-14 Thread kalimotxo
> > > Hi Paul, this sounds pretty good. I'm new to working with these type of objects, so I'll have to read through clearly. One thing I notice, if I understand your code correctly, is that I do not want to have to click a button to run the code, but rather have it in the middle of my sub(),

Re: $$Excel-Macros$$ Show listbox for user to click check boxes while macro is running

2016-10-14 Thread Paul Schreiner
There are several ways to accomplish something like this.What *I* would do personally is something like:Using VBA, I'd create a Dictionary object and cycle through the records, inserting entries in the Dictionary Object, thereby creating an array of unique values.Then, use the statement:sArray

$$Excel-Macros$$ Show listbox for user to click check boxes while macro is running

2016-10-14 Thread kalimotxo
Hello, I'm running a macro to process some data over several columns. At a midway point of the code, I need the macro to bring up a list of possible names. The user then can check the ones they do not want, click OK, and then the macro will go on to delete all records connected to that name.