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!

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/

Care to attach a sample (personal info removed) workbook so we know what you're needing assistance with ?

Thanks Logitech, I will give this a try.