+ Reply to Thread
Results 1 to 7 of 7

ComboBox & ListBox

  1. #1
    Registered User
    Join Date
    11-10-2013
    Location
    Bangalore.India
    MS-Off Ver
    Excel 2003
    Posts
    6

    ComboBox & ListBox

    Please Help me out with This

    I Have Created A Combox in UserForm , which should show the "Accounts" in the Dropdown.
    And when i Select Particular Account ...example "1" ,it should populate steps under it like X.Y.Z in ListBox

    Have used "ComboBox1.List = ThisWorkbook.Worksheets("Sheet3").Range("A1:A26").Value" to Display content under A
    which doesnt shows.. until i type something in Combox..!!!

    ------------------
    On Sheet
    ------------------
    A B
    Accounts 1
    1 X
    2 y
    3 Z

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,090

    Re: ComboBox & ListBox

    Sorry. My skill set does not include enough imagination to picture what your workbook, forms and code looks like. So, very difficult to offer suggestions with such a brief description.

    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: ComboBox & ListBox

    Hi ahneel

    Welcome to the Forum!!

    Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.

    Include in the attachment any code you're currently using (whether it works or not) and an "After" worksheet that demonstrates what you wish the output to be.

    To Attach a File:

    1. Click on Go Advanced
    2. In the frame Attach Files you will see the button Manage Attachments
    3. Click the button.
    4. A new window will open titled Manage Attachments - Excel Forum.
    5. Click the "Add Files"... button to locate your file for uploading.
    6. This will open a new window File Upload...Click "Select Files"
    7. Once you have located the file to upload click the Open button. This window will close.
    8. You are now back in the Manage Attachments - Excel Forum window.
    9. Click the "Upload Files" button and wait until the file has uploaded.
    10. Click the "Done" Button.
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  4. #4
    Registered User
    Join Date
    11-10-2013
    Location
    Bangalore.India
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: ComboBox & ListBox

    In Userform, when i select a item from ComboBox1 (no buttons) it should populate data in ListBox1.

    Data is on Sheet3 range A1:A26 (For Combox1) and B1:B26 (For ListBox1)



    Below code... works for ComboBox to display items, but until i type something in Combox :-(


    Private Sub ComboBox1_Change()
    ComboBox1.List = ThisWorkbook.Worksheets("Sheet3").Range("A1:A26").Value
    End Sub

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,090

    Re: ComboBox & ListBox

    If you want help resolving this, you need to post a sample workbook. Remove any sensitive data and any worksheets, etc., that are not relevant.

    No-one is going to create a workbook, name sheets, create a user form, add controls, etc., in order to test this.

  6. #6
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: ComboBox & ListBox


  7. #7
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,090

    Re: ComboBox & ListBox

    @cytop: thanks.

    @ahneel: ok, I'm out. Suggest you follow up on the other forum.


    Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

    Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

    Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

    Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 12-07-2012, 02:10 AM
  2. listbox to combobox
    By dcompagnone in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-12-2010, 04:16 PM
  3. ListBox or ComboBox - which to use??
    By matpj in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-10-2007, 07:36 AM
  4. comboBox vs Listbox
    By Steve in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-13-2006, 08:26 PM
  5. Combobox v Listbox
    By MBlake in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 04-24-2005, 07:09 AM

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