I am amazed at what you have accomplished very simply but I do not understand where you are storing the information in the Combobox1 and combobox2 for the drop down selection process
Please help - I really think I would benefit in my programming by utilising Userforms but I have always shied away from them Thanks in advance Brian Scotland On Jan 27, 4:52 pm, Ashish Pradhan <ashlyprad...@gmail.com> wrote: > Hello Ashish > > This file is amazing. Just as I had hoped for. Never ceases to amaze me > about the power of excel in the hands of people with expert minds like > yours.. :-) :-) > > Am adding some more stuff to the file. Hope to get it done with as less > help as possible. > > Thanks once again for the brilliant stuff. > > Ashish > > On 27/01/2011 11:51 AM, ashish koul wrote: > > > check this out > > > On Thu, Jan 27, 2011 at 11:13 AM, Ashish Pradhan > > <ashlyprad...@gmail.com <mailto:ashlyprad...@gmail.com>> wrote: > > > Hello Ashish > > > Excellent Stuff. One Request. Is it possible to freeze the > > following to accept only what is in the Drop Down list:? > > > 1. Name of the Waiter (Only Accept what is in the drop down) > > 2. Order (Only Accept what is in the drop down) > > > Also, The cursor begins with Table Number. Is it possible for the > > cursor to begin with the "Date of Order"? If I press the Tab key > > on the keyboard, the cursor moves around randomly and does not go > > to the next option. Can this be fixed? > > > The UserForm remains in view after "saving the data" and goes to > > the Details Sheet. Can the userform be closed after the data is saved? > > > Also, am looking at the way in which the sorting of dates is done > > in the Details Sheet. Am not sure what is happening. Can I look at > > it in more detail and request more help if required? > > > Thanks a lot > > > Ashish Pradhan > > > On 27/01/2011 09:36 AM, ashish koul wrote: > >> use this one > > >> On Thu, Jan 27, 2011 at 7:59 AM, ashish koul > >> <koul.ash...@gmail.com <mailto:koul.ash...@gmail.com>> wrote: > > >> check the attachment see if it helps > > >> On Wed, Jan 26, 2011 at 6:50 PM, Ashish Pradhan > >> <ashlyprad...@gmail.com <mailto:ashlyprad...@gmail.com>> wrote: > > >> Hello > > >> Much earlier I had sent a query regarding Userforms in > >> Excel and the group was spontaneous and kind enough to > >> solve my query exactly as I needed the output. > > >> I may not have been an active participant to the queries > >> (simply because my knowledge of excel is minuscule in > >> comparison with many of the group members) but I have > >> certainly tried many of the solutions posted by the > >> members. I like to call myself an "Excel Buff" and > >> occasionally think of various solutions to everyday and > >> practical problems. During a discussion with a friend, I > >> was of the opinion that a billing software can easily be > >> developed in excel. Something similar to the kinds we see > >> in hotels / restaurants. > > >> I began to work towards building such a software in Excel > >> using UserForms. Now I am stuck. I have attempted to make > >> a begining. Please see the attached Excel File. (Am using > >> Excel version 2003) > > >> The UserForm that I have created has a lot of bugs. Most > >> of it I think is in the naming of the Code and the Code > >> itself. > > >> Would someone be kind enough to please take a look at it. > > >> The Sheet "Main" has two hidden columns. > > >> Is it possible to Use the Data in these Column A (hidden) > >> as a drop down list in the User Form against "Order" in > >> the userform? Similarly, for Name of the Waiter in the > >> Userform, is it possible to have a drop down list as in > >> Column C? > > >> In Sheet "Details", my first Column starts with "Date" in > >> the format DD/MM/YYYY. If there a way to automatically > >> sort the Data in Sheet "Details". The primary sorting > >> should be on "Date" column and then by the "Table" Column.. > > >> At different stages, I have managed to get the userform > >> working, but the moment I add / modify some parts of it, > >> the compilation fails.. > > >> Need Any help possible. > > >> Thanks > > >> Ashish > > >> P.S: Assure you that this is not a professional / paid > >> project in any circumstances. This is purely something > >> which I have undertaken simply to satisfy my own > >> curiosity and usage of Excel.. > > >> -- > >> > >> ---------------------------------------------------------------------------------- > >> Some important links for excel users: > >> 1. Follow us on TWITTER for tips tricks and links : > >> http://twitter.com/exceldailytip > >> 2. Join our LinkedIN group @ > >> http://www.linkedin.com/groups?gid=1871310 > >> 3. Excel tutorials at > >> http://www.excel-macros.blogspot.com > >> <http://www.excel-macros.blogspot.com/> > >> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > >> <http://www.quickvba.blogspot.com/> > >> 5. Excel Tips and Tricks at > >> http://exceldailytip.blogspot.com > >> <http://exceldailytip.blogspot.com/> > > >> To post to this group, send email to > >> excel-macros@googlegroups.com > >> <mailto:excel-macros@googlegroups.com> > > >> <><><><><><><><><><><><><><><><><><><><><><> > >> Like our page on facebook , Just follow below link > >> http://www.facebook.com/discussexcel > > >> -- > > >> *Regards* > >> ** > >> *Ashish Koul* > >> *akoul*.*blogspot*.com <http://akoul.blogspot.com/> > >> *akoul*.wordpress.com <http://akoul.wordpress.com/> > >> My Linkedin Profile > >> <http://in.linkedin.com/pub/ashish-koul/10/400/830> > > >> PBefore printing, think about the environment. > > >> -- > > >> *Regards* > >> ** > >> *Ashish Koul* > >> *akoul*.*blogspot*.com <http://akoul.blogspot.com/> > >> *akoul*.wordpress.com <http://akoul.wordpress.com/> > >> My Linkedin Profile > >> <http://in.linkedin.com/pub/ashish-koul/10/400/830> > > >> PBefore printing, think about the environment. > > >> -- > >> > >> ---------------------------------------------------------------------------------- > >> Some important links for excel users: > >> 1. Follow us on TWITTER for tips tricks and links : > >> http://twitter.com/exceldailytip > >> 2. Join our LinkedIN group @ > >> http://www.linkedin.com/groups?gid=1871310 > >> 3. Excel tutorials athttp://www.excel-macros.blogspot.com > >> <http://www.excel-macros.blogspot.com/> > >> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > >> <http://www.quickvba.blogspot.com/> > >> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > >> <http://exceldailytip.blogspot.com/> > > >> To post to this group, send email to > >> excel-macros@googlegroups.com <mailto:excel-macros@googlegroups.com> > > >> <><><><><><><><><><><><><><><><><><><><><><> > >> Like our page on facebook , Just follow below link > >> http://www.facebook.com/discussexcel > > -- > > > > ---------------------------------------------------------------------------------- > > Some important links for excel users: > > 1. Follow us on TWITTER for tips tricks and links : > > http://twitter.com/exceldailytip > > 2. Join our LinkedIN group @ > > http://www.linkedin.com/groups?gid=1871310 > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > > <http://www.excel-macros.blogspot.com/> > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > <http://www.quickvba.blogspot.com/> > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > <http://exceldailytip.blogspot.com/> > > > To post to this group, send email to excel-macros@googlegroups.com > > <mailto:excel-macros@googlegroups.com> > > > <><><><><><><><><><><><><><><><><><><><><><> > > Like our page on facebook , Just follow below link > > http://www.facebook.com/discussexcel > > > -- > > > *Regards* > > ** > > *Ashish Koul* > > *akoul*.*blogspot*.com <http://akoul.blogspot.com/> > > *akoul*.wordpress.com <http://akoul.wordpress.com/> > > My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830> > > > PBefore printing, think about the environment. > > > -- > > ---------------------------------------------------------------------------------- > > Some important links for excel users: > > 1. Follow us on TWITTER for tips tricks and links : > >http://twitter.com/exceldailytip > > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > > > <><><><><><><><><><><><><><><><><><><><><><> > > Like our page on facebook , Just follow below link > >http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
