+ Reply to Thread
Results 1 to 2 of 2

Data Shown in List Box

  1. #1
    Forum Contributor
    Join Date
    02-16-2011
    Location
    Maharashtra, Thane
    MS-Off Ver
    Excel 2021
    Posts
    140

    Data Shown in List Box

    Hi,
    I have a worksheet in which there have some 14 rows. I have attached the sample file for reference.
    I need a userform in which some8 combo boxes required which is marked yellow color.
    When i will select 1st combo box of “A” column for ex. “Branch Office” only Branch records will be shown in List Box like “Sales Office”. When select “All” from drop down total records will be shown.
    2nd drop down is for “B” column where State names are mentioned. When i will select a State Name the particular state records will be shown in the list box under Branch Office / Sales Office.
    All the records will be shown as per Data>Filter.
    When i select Branch Office, State, Zone, Branch Status & Agreement Status the same data will filtered and shown in the list box. That particular data when i click a retrieve button it will copy my existing sheet named “Status”.
    I may select 2/3/5 filters at a time as per requirement. Please help. Thanks.
    List Box Data.xlsxList Box Data.xlsx

  2. #2
    Forum Contributor
    Join Date
    02-16-2011
    Location
    Maharashtra, Thane
    MS-Off Ver
    Excel 2021
    Posts
    140

    Re: Data Shown in List Box

    Hi, please solve my query if is it possible. Thanks.

+ 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: 9
    Last Post: 10-25-2013, 12:13 AM
  2. List of data to be shown using VBA in a Excel workbook
    By hsejar in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-11-2011, 07:04 AM
  3. Filter Results Shown In Data Validation List
    By Spencer in forum Excel General
    Replies: 19
    Last Post: 03-15-2011, 05:15 AM
  4. Named Ranges shown (or not shown) as blue means what?
    By wdeleo in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 07:05 AM
  5. [SOLVED] Named Ranges shown (or not shown) as blue means what?
    By wdeleo in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 06:05 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