There are various ways.
you can use additem in your code or you can use "RowSource" property
of the combo box.
for using property what u shud do is you type required data in cells.
then name those cells by selecting all the cells which u want to name
then right click it then select "Name a Range" and then give any name.
lets say MyTest
then use this name i.e. MyTest in the RowSource proprty of the combo box.
Note: Double quotes are not required for any name anywhere.
you can even hide those cells which has your data for combo box.
please let me know if you understand it or not.
i am sleepy going to bed :)
------------------------------------------------------------------------
*From:* BJthebear <brian.jerm...@gmail.com>
*To:* MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
*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 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
<mailto: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>
<mailto: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>
<mailto: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>
<mailto: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>
> >> <mailto: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>
<mailto: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>
> > <mailto: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
<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
<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
