Re: $$Excel-Macros$$ Help With UserForms

2011-01-29 Thread Ashish Pradhan
Thu, 27 January, 2011 11:36:44 PM *Subject:* Re: $$Excel-Macros$$ Help With UserForms 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 th

Re: $$Excel-Macros$$ Help With UserForms

2011-01-28 Thread hanumant shinde
and it or not. i am sleepy going to bed :) From: BJthebear To: MS EXCEL AND VBA MACROS Sent: Thu, 27 January, 2011 11:36:44 PM Subject: Re: $$Excel-Macros$$ Help With UserForms I am amazed at what you have accomplished very simply but I do not understand where

Re: $$Excel-Macros$$ Help With UserForms

2011-01-27 Thread Ashish Pradhan
Hello Hanumant Thanks a lot for your efforts. As always, this group has once again helped me to quickly solve my problems within the shortest possible time. Yes, I agree that many data validations are yet to be done. However, ideas are bouncing off me as I progress. Hopefully, ideas at a late

Re: $$Excel-Macros$$ Help With UserForms

2011-01-27 Thread Ashish Pradhan
Hello Brian In fact, I was similarly looking for the drop down selection process in the Combobox1 and Combobox2 to understand it better myself. I too, was unable to decipher the code suitably. But to be honest, I have not looked at the code in detail. I was rather hoping to do it over the wee

Re: $$Excel-Macros$$ Help With UserForms

2011-01-27 Thread ashish koul
this macro is adding the data to combo box before you make form visible if you check sheet1 cell d23 , d24, etc or a23, a24 its having values these values are added to combobox1 Sub OpenDetails() Dim i As Long For i = 23 To Sheets(1).Range("d23").End(xlDown).Row With OrderForm.ComboBox1 .AddIt

Re: $$Excel-Macros$$ Help With UserForms

2011-01-27 Thread BJthebear
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

Re: $$Excel-Macros$$ Help With UserForms

2011-01-27 Thread Ashish Pradhan
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 b

Re: $$Excel-Macros$$ Help With UserForms

2011-01-26 Thread Ashish Pradhan
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 possib