Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-30-2018, 07:14 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

Quote:
Originally Posted by macropod View Post
When I choose that type, I see four dropdown options:
• None
• PedKnock Statutes
• PedKnock Negligence Laundry List
• MORE TO COME
Are you running this on a Mac, or on a PC, when you encounter these issues?
I am running it on a PC. Yes, I see those DD list options too, but when I choose "PedKnock Statutes" or "PedKnock Negligence Laundry List," the corresponding text from the Excel spreadsheet is supposed to populate the appropriate paragraph below -- all I see is the paragraph number.

Quote:
Originally Posted by macropod View Post
You can choose them in any order. What you seem to want, though, is for the output order to be the initial dropdown order, regardless of the order in which the items are chosen. That would break the nexus between the dropdown selections and the output list. If I recode the macro so that subsequent entries are not deleted when changing a given response, it will be possible to go some way to addressing this by allowing users to change a previous response.
Not sure what you mean here, I can't choose them in any order (for example, no DD list appears next to #17 when I have only chosen responses for #1 and #2). I want to be able to (for example) choose a response for #2, then #17, then #24 (in which case the document at the bottom would just have "2. blah blah blah", "17. blah blah blah", and "24. blah blah blah" -- ideally (but not crucially) with blank paragraphs for the intervening numbers) and for the responses chosen for #2 and #24 not not to refresh/delete if I change the response chosen for #17.



Quote:
Originally Posted by macropod View Post
Yes, that would be possible, but surely you wouldn't want more dropdowns to be available for a given case type than the are valid responses!?
One of the possible responses is "Other" - which can be the response to multiple questions. So there can never be more DD lists available than valid responses.
Reply With Quote
  #2  
Old 05-16-2018, 02:05 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

Hi all. It's been a couple of weeks since my last post replying to Paul. I've spent many hours trying to do this myself. I've tried methods described in other posts, downloaded sample files that I've tried to modify to suit my needs, etc., but I'm in over my head. I'd really appreciate it if Paul or anyone else can help further. Thanks so much - I know everyone who contributes here does so out of the goodness of their heart and nothing else - and I really appreciate it.
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 02:58 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