+ Reply to Thread
Results 1 to 3 of 3

vba-populate listbox after selection from combo

  1. #1
    Registered User
    Join Date
    10-07-2008
    Location
    Singapore
    Posts
    11

    Question vba-populate listbox after selection from combo

    Scenario
    In my workbook i have worksheets that are named 01-Jan-2008,15-jan-2008,30-jan-2008...and i have almost 50 for each year.from 2007 to 2009

    I have created a userform where i have a Year combobox with values 2007,2008,2009 and an ok button
    then in the same form, i have a listbox and an Ok button and a back button

    i want the user to be able to pick the Year from the combobox
    once he specifies the year, the worksheets corresponding to that year should appear in the listbox...instead of populating it with all the 100+ wksheets i want the search narrowed down.

    Can anyone please help me out on this? any help is greatly appreciated! Thank u in advance!!
    Last edited by ACOM; 05-16-2009 at 05:44 PM.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,644

    Re: vba-populate listbox after selection from combo

    Something like the attached?
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    10-07-2008
    Location
    Singapore
    Posts
    11

    Thumbs up Re: vba-populate listbox after selection from combo

    thank u so much for the extremely prompt response...finally i have finished my task and i can relax a lil thanks to u!!!

    have a blessed week ahead!
    thank u sooo much i really appreciate the time you have taken to help me out!

+ 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