Re: $$Excel-Macros$$ VBA Numbers only in Textbox

2014-09-25 Thread Vaibhav Joshi
In that case you will need to as many copy of codes + *I did not do this for you. God is here working through me for you.* On Thu, Sep 25, 2014 at 11:29 AM, Mr_Bill egge...@gmail.com wrote: It requires a bit more than that. I change TextBox1 to wtBox1 now what about

Re: $$Excel-Macros$$ Fwd: FILTER REQUIREMENTS -- Colour of Filter should catch our eyes. -- It may help more persons.

2014-09-25 Thread big smile
Respected All , What happen every body is silent. No body get any way out .. How to over come this requirements .. On Thu, Sep 25, 2014 at 9:59 AM, big smile bigsmile...@gmail.com wrote: Respected Sir , I think i have not properly explain you. I want when we used filter then full column

Re: $$Excel-Macros$$ Fwd: FILTER REQUIREMENTS -- Colour of Filter should catch our eyes. -- It may help more persons.

2014-09-25 Thread Ashish Kumar
Hi, So, you want to filter your data according to rows not columns...!! Regards Ashish -- 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

Re: $$Excel-Macros$$ Fwd: FILTER REQUIREMENTS -- Colour of Filter should catch our eyes. -- It may help more persons.

2014-09-25 Thread big smile
Sir, I want filter according to column only but it may be at a time two filter when i use filter in B and F or may be more combination then that particularly full column colour should change so that we can identify easily where we have out filter .. On Thu, Sep 25, 2014 at 4:13 PM, Ashish

Re: $$Excel-Macros$$ Fwd: FILTER REQUIREMENTS -- Colour of Filter should catch our eyes. -- It may help more persons.

2014-09-25 Thread Ashish Kumar
Ok friend call me. -- 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, like Please Help,

Re: $$Excel-Macros$$ Fwd: FILTER REQUIREMENTS -- Colour of Filter should catch our eyes. -- It may help more persons.

2014-09-25 Thread big smile
Which no to call .. You have written called me On Thu, Sep 25, 2014 at 4:20 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: Ok friend call me. -- 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 @

Re: $$Excel-Macros$$ Fwd: FILTER REQUIREMENTS -- Colour of Filter should catch our eyes. -- It may help more persons.

2014-09-25 Thread Vaibhav Joshi
chk this.. Row1 will highlight column no. which has filter. Cheers!! + *I did not do this for you. God is here working through me for you.* On Thu, Sep 25, 2014 at 9:16 AM, big smile bigsmile...@gmail.com wrote: Respected Excel Guru / Friends I think many of our friend is facing this

Re: $$Excel-Macros$$ Fwd: FILTER REQUIREMENTS -- Colour of Filter should catch our eyes. -- It may help more persons.

2014-09-25 Thread big smile
Thanks a lot Vaibhav Bhai. Your solution works for all the files of excel in my folders. It is great soultion. --- Thanks a lot yaar . 1] I have to keep safe your send files so that it will work or if i remove the file then also it will work for other files 2] If i have to change the colur

Re: $$Excel-Macros$$ VBA Numbers only in Textbox

2014-09-25 Thread Paul Schreiner
What I would do is move the entire code to a Function, passing the textbox content. Have the function perform the test, then return something significant. (like true/false or a value to replace the textbox content) You still have to have a _Change event for each textbox, but the code is much

Re: $$Excel-Macros$$ Urgent SQL code required

2014-09-25 Thread Paul Schreiner
I found this with a simple Google Search: sql select multiple rows into one string I tested it with one of my Oracle Tables (using applicable field names) and it seemed to work. SELECT Cust_ID, LISTAGG(Prod_Range, '/') WITHIN GROUP (ORDER BY Prod_Range) FROM USE_YOUR_TABLENAME_HERE

Re: $$Excel-Macros$$ Fwd: FILTER REQUIREMENTS -- Colour of Filter should catch our eyes. -- It may help more persons.

2014-09-25 Thread Ashish Kumar
Hi, Check this. Filter data, any 1 column then don't remove the Filter, thenafter filter 2nd Column then filter 3rd Column. It will be change header color for each column. Regards Ashish -- 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$$ Fwd: FILTER REQUIREMENTS -- Colour of Filter should catch our eyes. -- It may help more persons.

2014-09-25 Thread big smile
Ashish bhai I am sorry it does not work. But Viabhav Bhai file works . if i want to apply this to other excel fiels then I have to keep open Master file- Initial file open -- Vaibhav Bhai send then work for all files.. Do not feel hurt .. Just to share what is happening On Thu, Sep

$$Excel-Macros$$ please provide the excel vba code for creating ms access table headers table

2014-09-25 Thread Renukachari Kasee
Dear experts, please provide the excel vba code macro for creating ms access table headers table *(¨`•.•´¨) Always`•.¸(¨`•.•´¨) Keep(¨`•.•´¨)¸.•´ Smiling!!`•.¸.•´Thanks Regards´¨) ¸ •´ ¸.•*´¨) ¸.•*¨) (¸.•´ (¸.•* ♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥...♪♪♪* *P Let us do our best

$$Excel-Macros$$ URGENT HELP( CONDITION SEARCH OF UNIQUE TEXT)

2014-09-25 Thread SUDHIR VERMA
Dear Experts, Kindly resolve my problem. Explanation in attached workbook. Thanking You Regards Sudhir -- 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

Re: $$Excel-Macros$$ URGENT HELP( CONDITION SEARCH OF UNIQUE TEXT)

2014-09-25 Thread Ganesh N
Hi sudhir, PFA. Just given if condition. Regards, Ganesh N On Thu, Sep 25, 2014 at 10:44 PM, SUDHIR VERMA newinex...@gmail.com wrote: Dear Experts, Kindly resolve my problem. Explanation in attached workbook. Thanking You Regards Sudhir -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in