Re: $$Excel-Macros$$ Re: Mandatory Cell Entry

2013-01-20 Thread pankaj gmail account
Dear All, Pleae help to resolve the query. DEar Prince Please check On Tue, Jan 15, 2013 at 12:40 PM, pankaj gmail account wrote: > Dear Gurus > > Please help. > > Regards, > Pnkaj > > On Thu, Jan 10, 2013 at 5:10 PM, Prince wrote: > >> Ok Pankaj >> i can only reply in evening. >> >> rega

Re: $$Excel-Macros$$ Re: Mandatory Cell Entry

2013-01-14 Thread pankaj gmail account
Dear Gurus Please help. Regards, Pnkaj On Thu, Jan 10, 2013 at 5:10 PM, Prince wrote: > Ok Pankaj > i can only reply in evening. > > regards > Prince > > > On Thursday, January 10, 2013 5:02:06 PM UTC+5:30, Pankaj wrote: > >> Don't use differnt mails. >> >> REgards, >> Pankaj >> >> On Thu, J

Re: $$Excel-Macros$$ Re: Mandatory Cell Entry

2013-01-10 Thread Prince
Ok Pankaj i can only reply in evening. regards Prince On Thursday, January 10, 2013 5:02:06 PM UTC+5:30, Pankaj wrote: > > Don't use differnt mails. > > REgards, > Pankaj > > On Thu, Jan 10, 2013 at 2:22 PM, Prabhakar S H > > > wrote: > >> Hi Prince, >> >> Its not working. >> >> Can you

Re: $$Excel-Macros$$ Re: Mandatory Cell Entry

2013-01-10 Thread pankaj gmail account
s.com >> *Date: *Sat, 5 Jan 2013 20:03:55 -0800 (PST) >> *To: * >> *ReplyTo: * excel-macros@googlegroups.com >> *Subject: *$$Excel-Macros$$ Re: Mandatory Cell Entry >> >> yes it is possible, pleas follow the following steps. >> >> 1:DATA Tab->Data

Re: $$Excel-Macros$$ Re: Mandatory Cell Entry

2013-01-10 Thread pankaj gmail account
Don't use differnt mails. REgards, Pankaj On Thu, Jan 10, 2013 at 2:22 PM, Prabhakar S H wrote: > Hi Prince, > > Its not working. > > Can you send me example with this formula. > > Rgds, > Prabhakar > > On Sunday, January 6, 2013 9:33:55 AM UTC+5:30, Prince wrote: > >> yes it is possible, pleas

$$Excel-Macros$$ Re: Mandatory Cell Entry

2013-01-10 Thread Prabhakar S H
Hi Prince, Its not working. Can you send me example with this formula. Rgds, Prabhakar On Sunday, January 6, 2013 9:33:55 AM UTC+5:30, Prince wrote: > yes it is possible, pleas follow the following steps. > > 1:DATA Tab->Data validation->Data validation->Select *Custom *in allow > section

Re: $$Excel-Macros$$ Re: Mandatory Cell Entry

2013-01-08 Thread pankaj gmail account
* Prince > *Sender: * excel-macros@googlegroups.com > *Date: *Sat, 5 Jan 2013 20:03:55 -0800 (PST) > *To: * > *ReplyTo: * excel-macros@googlegroups.com > *Subject: *$$Excel-Macros$$ Re: Mandatory Cell Entry > > yes it is possible, pleas follow the following steps. > > 1:DATA T

Re: $$Excel-Macros$$ Re: Mandatory Cell Entry

2013-01-05 Thread mohan . pandey87
bject: $$Excel-Macros$$ Re: Mandatory Cell Entry yes it is possible, pleas follow the following steps. 1:DATA Tab->Data validation->Data validation->Select *Custom *in allow section-> In formula box Write *=A1<>"" *->Select *Error alert tab* on same popup ->in Style

$$Excel-Macros$$ Re: Mandatory Cell Entry

2013-01-05 Thread Prince
Yes one more thing Uncheck the ignore blank option Regards Prince On Saturday, January 5, 2013 9:10:29 AM UTC+5:30, Pankaj wrote: > > Dear Gurus > > I want to make a excel data entry form in which i want some cells to be > mandatory and some can be left out. But with sequence > > Like > >

$$Excel-Macros$$ Re: Mandatory Cell Entry

2013-01-05 Thread Prince
yes it is possible, pleas follow the following steps. 1:DATA Tab->Data validation->Data validation->Select *Custom *in allow section-> In formula box Write *=A1<>"" *->Select *Error alert tab* on same popup ->in Style select *stop*->in error message option give your message-> And at last* OK*