#1
|
|||
|
|||
A Userform and 4 Cascading List Boxes
I am confused and confounded (in over my head). I want to develop a Userform in Excel that will help me enter data into a Corrections Sheet Listing (First sheet in the Workbook). Excel in Office 365
1. I have four existing tables: Main Group (Interior and Exterior), Subgroup (12 items for Interior and 9 items for Exterior), Items Listing (with Subgroup Column Included), Corrections List (Specific corrections, with a CID number (Unique for each correction) and 1-6 corrections for each Item in the Items Listing). 2. I wanted to use cascading list boxes to drill down through the tables and select a proper correction: and put that correction in a text box on the Userform. Click on the Correction text in the Userform which would transfer it to a corrections form (Worsheet). Clicking on the Text box would transfer the text to the Worksheet, clear the Userform and start the process over again. 3. So far, I have the Main Group selection complete using and with a “Select Case” in the VBA Editor. I have a “Rowsource” Sub (Case is = 0 SubGroup.RowSource = "SubGroup_Exterior” and Case is = 1 SuGroup.RowSource = “SubGroup_Interior”) to populate the Subgroup List with one of the appropriate Subgroup Listings. 4. I have tried using “Index and Match” and “Index, Match and Match” and “Application.WorsheetFunction.” as part of my VBA. I cannot get the Item List and Corrections List to function or match with the Subgroup Lists. Help please! |
#2
|
|||
|
|||
Here are two resources that explain the process and provide an example file for review:
http://www.thesmallman.com/cascading-drop-down-lists/ http://datapigtechnologies.com/blog/...ing-listboxes/ |
#3
|
|||
|
|||
Care to attach a sample (personal info removed) workbook so we know what you're needing assistance with ?
|
#4
|
|||
|
|||
Thanks Logitech, I will give this a try.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Help with cascading dropdown list | SaraO | Word VBA | 45 | 02-05-2023 05:33 PM |
Cascading List Word 2010 | Marvel | Word VBA | 11 | 05-14-2016 02:08 AM |
Linking WORD Cascading Dropdown Boxes to Excel | music_al | Word VBA | 6 | 02-15-2016 03:56 PM |
Using combobox to pass data from an Excel spread sheet to text boxes on userform | Stewie840 | Word VBA | 14 | 12-17-2015 10:13 PM |
Template opens with userform ; non-checked boxes should lead to deletion of corresp paragraphs | samszaf | Word | 1 | 09-07-2015 09:52 AM |