+ Reply to Thread
Results 1 to 11 of 11

Multiple Combo Boxes

  1. #1
    Registered User
    Join Date
    04-07-2008
    Posts
    19

    Multiple Combo Boxes

    Hi there,
    I have a manualy constructed user form which has 3 data validation lists.
    Sources:
    B7 = List 1
    B12:B15 = List 2
    B17:B20 and C17:C20 = List 3
    These operate fine but I wish to replace the dropdown validation boxes and replace them with Combo boxes so that users are able to view the complete lists and also offer the option of inputting an item not included in the validation list if required.
    I have tried many variations of input but my knowledge base is inadequate!
    Mainly I end up with the combo box working on one cell only!
    Can someone please advise:
    1. Do I have to raise 1 combo box per cell?
    2. What vba code is necessary to make them all work?
    Regards,
    OldSoldier

  2. #2
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Multiple Combo Boxes

    oldsolder could you please post a some sample file?
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

  3. #3
    Registered User
    Join Date
    04-07-2008
    Posts
    19

    Re: Multiple Combo Boxes

    Hi Pike,
    I appear to be unable to attach the file, maybe it is too big to meet the system.
    I could maybe e-mail to you it as an attachement?
    Rgds,
    OldSoldier

  4. #4
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Multiple Combo Boxes

    Can you could zip the file and then attach it?

  5. #5
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Multiple Combo Boxes

    Have a look at this example from Dave
    I think its what you want
    Attached Files Attached Files

  6. #6
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Multiple Combo Boxes

    Rereading the question you need an Active X combobox form the tools palaet

    It will have a list range that you can select

    I'll check back in a hour or so as the live telecast of the war beteen the West and East Islands of australia has just started

  7. #7
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Multiple Combo Boxes

    Back the Kiwis are all over us and lead 19 to 6 battles lost for another year any who...
    the attachment has the activeXcontrols
    Right click and veiw propoerties to see the named ranges
    Attached Files Attached Files

  8. #8
    Registered User
    Join Date
    04-07-2008
    Posts
    19

    Re: Multiple Combo Boxes

    Hi Pike,
    I have sent a copy of this file to the operators of this site in the hope that they will be able to assist in the upload. If they can I believe that you will see what my intention is.
    Regards,
    OldSoldier

    Ps. Pity about the result, by the time the next is played I should be resident in your country, can't wait!!

  9. #9
    Registered User
    Join Date
    04-07-2008
    Posts
    19

    Re: Multiple Combo Boxes

    Hi Pike,
    I have deleted several pages, all very similar, to reduce the size of the file.
    It seems to have worked.
    The required lengths of combo box displays are:
    B7 = 15 lines
    B12:B15 = 40 lines
    B17:C20 = 25 lines
    Hope that this makes sense to you.
    Regards,
    OldSoldier
    Attached Files Attached Files

  10. #10
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Multiple Combo Boxes

    I've set up three cell with the active x controls
    you can copy and paste them
    then right click and change the properties values as desired
    dont forget to exit design mode
    Attached Files Attached Files

  11. #11
    Registered User
    Join Date
    04-07-2008
    Posts
    19

    Re: Multiple Combo Boxes

    Hi Pike,
    Thanks for your assistance. I will now go away and work on this.
    Regards,
    OldSoldier

+ 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