Dear Prince and Lalit Thanks for response. what i wanted in a excel file:-
Student ID Class Subject Marks(Mandatory) 123 V Maths 345 V Maths 123 V English 456 V Maths 123 V Hindi Click on *student id(123)* data Entry form should open , Enter Marks and save it as soon it is saved next record should open but marks entered records should not visible in marks field. data should saved with mandatory fields. Thanks Pankaj Michael On Sun, Jan 6, 2013 at 9:43 AM, <mohan.pande...@gmail.com> wrote: > ** > Hi Pankaj > > Why don't you use user form for the same with better features. > > Regards, > Lalit Mohan > Sent from BlackBerry® on Airtel > ------------------------------ > *From: * Prince <prince141...@gmail.com> > *Sender: * excel-macros@googlegroups.com > *Date: *Sat, 5 Jan 2013 20:03:55 -0800 (PST) > *To: *<excel-macros@googlegroups.com> > *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 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* > > > That's All > > 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 >> >> Name (Mandatory) >> Address (Mandatory) >> Phone ( not mandatory) >> >> *first field entry should be name, he cannot move to phone directly >> until name is filled. is it possible in Excel? >> *-- >> >> Thanks >> Pankaj Kumar >> 9910075248 >> > -- > 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, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > > > > -- > 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, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > > > -- Thanks Pankaj Kumar 9910075248 -- 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, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.