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 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
<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
--
----------------------------------------------------------------------------------
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.
--
----------------------------------------------------------------------------------
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
