Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #14  
Old 04-24-2018, 08:54 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,467
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

I suspect the Run-time error '5825' has something to do with your Mac Parallels environment; I'm not getting it on my PC. That said, because the 'MV Pedestrian Knockdown' Case Type contains duplicate entries (as do most others), I expect you'll get a Run-time error '6215' at the line:
If strTmp <> "" Then .DropdownListEntries.Add Text:=strTmp
That can be overcome by using:
On Error Resume Next
If strTmp <> "" Then .DropdownListEntries.Add Text:=strTmp
On Error GoTo 0
for testing only, as your final version shouldn't have duplicates.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
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 01:49 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