Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-25-2018, 02:59 PM
macropod's Avatar
macropod macropod is offline Userform with Multiple Cascading Drop Down Lists Populated with External Source Data Windows 7 64bit Userform with Multiple Cascading Drop Down Lists Populated with External Source Data Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,465
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by venganewt View Post
You said the code is not complete -- I assume you intended to accomplish only the basic functionality (i.e., the Response Type list being dependent on the chosen Case Type, and each chosen Response Type populating the corresponding numbered paragraph), and not the more advanced functionality (i.e., having the "Common" responses appear as list items for all Response Types rather than "Common" itself being a Response Type, and the functionality I described in the highlighted portions of the template).
No, but I didn't want to go too far down the coding road only to find I was acting on the wrong premise. With Case Types, for example, the code presently only allows you to have one. Similarly, if you choose a Response Type, that type is removed from the next dropdown to prevent the same Response Type being chosen more than once. And, if the user goes back and changes a previously-selected Response Type, all subsequent Response Types that might have been chosen are deleted. Clearly, if users can switch Case Types, the current approach isn't going to work and responsibility for maintaining the nexus between Case Types and successive choices of Response Types may end up falling more heavily on the user.



I'm not sure what lies behind the error message you were getting, but it may cease to be an issue once the above is addressed.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #2  
Old 04-25-2018, 03:11 PM
venganewt venganewt is offline Userform with Multiple Cascading Drop Down Lists Populated with External Source Data Mac OS X Userform with Multiple Cascading Drop Down Lists Populated with External Source Data Office for Mac 2011
Novice
Userform with Multiple Cascading Drop Down Lists Populated with External Source Data
 
Join Date: Oct 2014
Posts: 13
venganewt is on a distinguished road
Default

Yes, only one Case Type should be chosen, but the user may make a mistake and want to switch it later. Doing that should delete all Response Types that may have been chosen. But changing a previously selected Response Type shouldn't delete all subsequent response types. Also, users should be able to choose Response Types out of order -- e.g., pick one for #3 and #6 before deciding on what to pick for #2 -- and if they do that, then the intervening numbers should be inserted as blank numbered paragraphs in the output at the bottom. (Btw, "Response Types" are really just "Responses" -- obviously just a name thing that I can change later, but just in case that affects how you're conceptualizing it.)

Thanks again for all of this!
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Userform with Multiple Cascading Drop Down Lists Populated with External Source Data Issue Using Word Document with Cascading Drop Down Lists LynnMac2016 Word VBA 3 04-06-2016 06:15 AM
Reference external data in drop-down lists jeffk Excel 1 01-01-2016 09:13 AM
Userform with Multiple Cascading Drop Down Lists Populated with External Source Data drop down list from external data source Excel 2007? Intruder Excel 1 08-03-2012 05:41 AM
Userform with Multiple Cascading Drop Down Lists Populated with External Source Data vba change external data source excelledsoftware Excel Programming 1 07-17-2012 04:22 AM
Userform with Multiple Cascading Drop Down Lists Populated with External Source Data Refresh of data from external source Jirik61 Excel Programming 3 07-13-2012 01:40 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:10 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