+ Reply to Thread
Results 1 to 2 of 2

Excel Userform combobox or checkbox?

  1. #1
    Forum Contributor
    Join Date
    01-16-2009
    Location
    Ill.
    MS-Off Ver
    Excel 2010
    Posts
    190

    Excel Userform combobox or checkbox?

    Hello - - I'm looking to use a userform from Excel that will act like the filtering of a spreadsheet. The reason I want to use a userform is that this will be made available to another department so I want some flexibility with providing a breakout of what's being selected via the userform.

    So, what I have is a list of employees, about 13k rows and 10 or so columns. The columns are like Name, ID, Main Dept, Dept, Sub-Dept, Cost Center, Cost Center Description (L), Job Title (F). I'd vision this userform to have a combobox (multi-select) for 1) Main Dept (I), Sub-Dept (J), Cost Center Description (M).

    A textbox will show the entire count, say 13100. As the user selects from the first combobox, Main Dept, (for example Technology), the textbox reflects at total count of say, 5000 employees. When the user selects the next combobox, Sub-Dept, that all departments that roll into Technology are listed and if the user check or selects two departments in the list, the texbox shows the total from that, say 2000 employees. From there a user can select Sub-Dept and/or Cost Center...and so on.

    Hope that makes sense...I'm attaching a mocked - test file for review..
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    01-16-2009
    Location
    Ill.
    MS-Off Ver
    Excel 2010
    Posts
    190

    Re: Excel Userform combobox or checkbox?

    Update - after some review/research, I think what I need is a series of listbox (multiselect set to 1), where by after each item selected the row count text box updates...Hoping someone might have example of two multi select boxes and the text box...Thanks for reading!

+ 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. [SOLVED] send data from userform combobox to userform combobox
    By cfinch100 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-18-2013, 04:47 PM
  2. [SOLVED] Excel Userform: Populate other controls (i.e. textbox & combobox) based on combobox select
    By MileHigh_PhD in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-22-2013, 04:50 PM
  3. Best Placement of Checkbox on Multipage Userform - Excel VBA
    By eemiller1997 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-09-2013, 03:36 PM
  4. Userform / Checkbox information Help Excel 2007
    By Excelnoub in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-07-2013, 12:24 PM
  5. [SOLVED] Excel CheckBox on UserForm Event Loops
    By ptnagle in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-26-2005, 04:06 PM

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