+ Reply to Thread
Results 1 to 12 of 12

dropdown lists

  1. #1
    Registered User
    Join Date
    05-08-2007
    Posts
    7

    dropdown lists [resolved]

    Hello,

    I have a first drop down list with 4 possible selections. When a selection is made, I would like another dropdown list to appear with different values, depending on the initial selection.

    Many thanks for your replies.
    S.
    Last edited by szermat; 05-08-2007 at 07:54 AM.

  2. #2
    Forum Contributor stevebriz's Avatar
    Join Date
    09-07-2006
    Location
    Santiago Chile
    Posts
    389
    Are these dropdown list boxes on a userform?
    VBA - The Power Behind the Grid

    Posting a sample of your workbook makes it easier to look at the Issue.

  3. #3
    Forum Contributor stevebriz's Avatar
    Join Date
    09-07-2006
    Location
    Santiago Chile
    Posts
    389
    oops I see this is marked resolved now...Please disregard my last post

  4. #4
    Registered User
    Join Date
    03-31-2007
    Posts
    26
    Quote Originally Posted by stevebriz
    oops I see this is marked resolved now...Please disregard my last post
    May i know what the solution to this problem? I was wondering whether is it possible to do in excel?

  5. #5
    Forum Contributor stevebriz's Avatar
    Join Date
    09-07-2006
    Location
    Santiago Chile
    Posts
    389
    here is an example if you are using a userform with two comboboxes


    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    05-11-2007
    Location
    Bangalore, India
    MS-Off Ver
    MS Office 2013
    Posts
    58

    Number to word

    Hi,
    Can you help me out How to convert numbers to words.

    eg: Cell1: 2120
    Cell2: Two thousand one hundred and twenty.

    Pls help me out in this.

  7. #7
    Forum Contributor stevebriz's Avatar
    Join Date
    09-07-2006
    Location
    Santiago Chile
    Posts
    389
    This really should be in another thread.

    To answer you question...you can look at this:

    http://www.ozgrid.com/VBA/ValueToWords.htm

  8. #8
    Registered User
    Join Date
    03-31-2007
    Posts
    26
    Quote Originally Posted by stevebriz
    here is an example if you are using a userform with two comboboxes


    Please Login or Register  to view this content.
    Can this code be apply to dropdown list too coz i don't have any combobox in my worksheet?

  9. #9
    Forum Contributor stevebriz's Avatar
    Join Date
    09-07-2006
    Location
    Santiago Chile
    Posts
    389
    Are you using a named range for the validation dropdown lists or are you just entering comma sperated values?

  10. #10
    Registered User
    Join Date
    03-31-2007
    Posts
    26
    Quote Originally Posted by stevebriz
    Are you using a named range for the validation dropdown lists or are you just entering comma sperated values?
    named range

  11. #11
    Forum Contributor stevebriz's Avatar
    Join Date
    09-07-2006
    Location
    Santiago Chile
    Posts
    389
    The macro in this Post is for comboboxes not dropdown through data validation. Cascading Dropdowns can be done...but it takes a bit more coding.

  12. #12
    Registered User
    Join Date
    03-31-2007
    Posts
    26
    Quote Originally Posted by stevebriz
    The macro in this Post is for comboboxes not dropdown through data validation. Cascading Dropdowns can be done...but it takes a bit more coding.
    I see. Then it is okie. Thanks for your kind help.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1