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 later
stage will not affect the work done at the earlier stage drastically.
Thanks once again for your help. Excellent work.
Thanks
Ashish
On 28/01/2011 02:30 AM, hanumant shinde wrote:
File attached.
there are many validations can be done on this please do that.
data is going to proper cells now but there should be validations for
data.
e.g. in date text box if u write "jsdhg" it will accept this also and
so on. there shud b data validation for this.
------------------------------------------------------------------------
*From:* Ashish Pradhan <ashlyprad...@gmail.com>
*To:* Excel Help <excel-macros@googlegroups.com>
*Sent:* Wed, 26 January, 2011 6:50:08 PM
*Subject:* $$Excel-Macros$$ Help With UserForms
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
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
<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
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
