Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-02-2017, 08:27 AM
TheSwede TheSwede is offline A Userform and 4 Cascading List Boxes Windows 10 A Userform and 4 Cascading List Boxes Office 2016
Novice
A Userform and 4 Cascading List Boxes
 
Join Date: Apr 2017
Posts: 2
TheSwede is on a distinguished road
Post 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!
Reply With Quote
  #2  
Old 04-02-2017, 08:53 AM
Logit Logit is online now A Userform and 4 Cascading List Boxes Windows 10 A Userform and 4 Cascading List Boxes Office 2007
Expert
 
Join Date: Jan 2017
Posts: 529
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

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/
Reply With Quote
  #3  
Old 04-02-2017, 10:39 AM
NoSparks NoSparks is offline A Userform and 4 Cascading List Boxes Windows 7 64bit A Userform and 4 Cascading List Boxes Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
Default

Care to attach a sample (personal info removed) workbook so we know what you're needing assistance with ?
Reply With Quote
  #4  
Old 04-02-2017, 01:27 PM
TheSwede TheSwede is offline A Userform and 4 Cascading List Boxes Windows 10 A Userform and 4 Cascading List Boxes Office 2016
Novice
A Userform and 4 Cascading List Boxes
 
Join Date: Apr 2017
Posts: 2
TheSwede is on a distinguished road
Default

Thanks Logitech, I will give this a try.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
A Userform and 4 Cascading List Boxes Help with cascading dropdown list SaraO Word VBA 45 02-05-2023 05:33 PM
A Userform and 4 Cascading List Boxes Cascading List Word 2010 Marvel Word VBA 11 05-14-2016 02:08 AM
A Userform and 4 Cascading List Boxes Linking WORD Cascading Dropdown Boxes to Excel music_al Word VBA 6 02-15-2016 03:56 PM
A Userform and 4 Cascading List Boxes 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

Other Forums: Access Forums

All times are GMT -7. The time now is 02:02 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft