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 at http://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 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
--
----------------------------------------------------------------------------------
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
