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

2016-10-17 Thread kalimotxo
; *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > - > > > On Monday, October 17, 2016 10:

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

2016-10-17 Thread kalimotxo
ess you > can't have it all! > *Paul* > ----- > > > > > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever

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(),

$$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.

$$Excel-Macros$$ Variable Workbook name used in range formula

2009-09-08 Thread kalimotxo
Hello all, new to group! I will contribute as I am able, but to start, I am really hoping someone can help me with a problem. I have a named workbook as follows: CarrierGrid = Range(O CStr(R)) Range(Control!B4).Value .xls This is giving me CarrierGrid as HDMU 08.31.xls, which is what it