Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #15  
Old 04-25-2018, 06:36 AM
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

Thanks Paul. I was able to get around the 5825 by changing the location of the files.

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).

With that in mind, the basic functionality worked the first time I select a Case Type and then selected one or more Response Types. But when I tried to do anything else -- like change the Case Type, or change an earlier Response Type than the current one (e.g., if I have added a Response Type for #3, then try to change the Response Type for #1 or #2) -- I either got error messages or the functionality stopped. I know it is generally difficult to address code problems unless I describe each action or series of actions that causes a problem, but I ran into a problem doing anything beyond initially selecting a Case Type and then one or more Response Types. On your end, is the basic functionality maintained beyond that?

Thanks again so much for your help, and I don't want to impose or take advantage of your generosity -- please let me know if we reach a point where you feel it would be more appropriate to proceed with a commercial arrangement offline.
Reply With Quote
 



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 12:23 AM.


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