Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #11  
Old 03-08-2024, 10:43 AM
bossroy bossroy is offline Help! - multiselect userform listbox with dependent drop down Windows 10 Help! - multiselect userform listbox with dependent drop down Office 2016
Novice
Help! - multiselect userform listbox with dependent drop down
 
Join Date: Feb 2024
Posts: 9
bossroy is on a distinguished road
Default

I apologize if I am being dense.

From your example if the user selects both Ford and Toyota then the dependent list should list Auto Pilot, Warp Drive, and Tires. This is the result I want.

But what if the user selects only one model? Wouldn't Tires only be "saved" under one of the models cases and not be available to both individually?

If the model is selected individually:
Ford>Auto Pilot, Tires
Toyota>Warp drive, Tires

If multiple models are selected:
Ford & Toyota>Auto pilot, Warp Drive, Tires

I don't want Tires listed twice if both models are selected, just have Tires be available to both modules individually AND if both models are selected together.

Is the only way to accomplish this to have a third case which which is Ford and Toyota and have its own list?

This is the best I could come up with and would be very difficult in the end.

Case "Ford"
DropdownListEntries.Add "Auto Pilot"
DropdownListEntries.Add "Tires"
Case "Toyota"
DropdownListEntries.Add "Warp Drive"
DropdownListEntries.Add "Tires"
Case "Ford", "Toyota"
DropdownListEntries.Add "Auto Pilot"
DropdownListEntries.Add "Warp Drive"
DropdownListEntries.Add "Tires"


Thank you as always!
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Dynamic Userform multiselect listbox populate trevorc Excel Programming 1 12-03-2018 02:49 PM
Multiselect listbox - custom outlook form A_Balt Outlook 0 07-19-2018 09:36 AM
Help! - multiselect userform listbox with dependent drop down Moving Selected Items from a Multiselect Listbox on a userform to a bookmark in Word marksm33 Word VBA 3 01-15-2015 07:55 PM
Help! - multiselect userform listbox with dependent drop down This is a Userform LIstbox queston: A variable does not set to the value of a listbox CatMan Excel 1 08-08-2014 09:41 AM
Data from Excel to Listbox multiselect to Word marksm33 Word VBA 2 02-18-2014 08:30 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:38 PM.


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