Re: $$Excel-Macros$$ VBA Date Picker xls

2014-01-16 Thread amar takale
Dear Bé Trần Văn Thanks sir for solution in another way but if I would got answer as per my requirement then it is very simple me. AmarT On Wed, Jan 15, 2014 at 10:23 PM, Bé Trần Văn wrote: > Cell F6 or H6 Click to show Calendar. > Select a date and click outside to hide the calendar. > > 2014

Re: $$Excel-Macros$$ VBA Date Picker xls

2014-01-15 Thread amar takale
Dear Bé Trần Vă, Thanks very muchfor solution But if i want to Fixed cell in sheet then how to work code Bcos I fixed two cell in my sheet if there click calender then date show that specific cell only not anywere in sheet. Appreciate Help sir Regards Amar On Wed, Jan 15, 2014 at 3:26 PM, Bé

$$Excel-Macros$$ VBA Date Picker xls

2014-01-14 Thread amar takale
Dear all Experts, PFA with all detailed. Regards Amar T -- 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. Po

Re: $$Excel-Macros$$ VBA DATE

2010-05-11 Thread Dilip Pandey
Hi Sundarvelan, Same conditional formatting can be done using vba coding (Macros)...!! @ Deepak, please transform that into vba coding and provide to Sundervelan.. I think that would be helpful for him. Thanks. -- Thanks & Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 981

Re: $$Excel-Macros$$ VBA DATE

2010-05-09 Thread Sundarvelan N
Hello Friends, I need to do this using VBA Coding. Please help me Thanks, Sundarvelan On Sun, May 9, 2010 at 8:38 PM, deepak kumar wrote: > Hi Sundar, > > You can do it with conditional formatting, I've attached a work to show you > how to do it, you just need to check the formula in conditiona

Re: $$Excel-Macros$$ VBA DATE

2010-05-09 Thread deepak kumar
Hi Sundar, You can do it with conditional formatting, I've attached a work to show you how to do it, you just need to check the formula in conditional formatting option. Thanks On Fri, May 7, 2010 at 5:02 AM, Sundarvelan N wrote: > Hi Friends, > > Can any one help me to solve the below conditi

$$Excel-Macros$$ VBA DATE

2010-05-07 Thread Sundarvelan N
Hi Friends, Can any one help me to solve the below condition *"HIGHLIGHT ANYTHING OVER 30 DAYS SINCE LAST ACTION FILL IN COLOR YELLOW"* Thanks, N.Sundarvelan -- -- Some important links for excel users: 1. Follow us