![]() |
|
|
Thread Tools | Display Modes |
#14
|
||||
|
||||
![]()
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] |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
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 |
![]() |
Intruder | Excel | 1 | 08-03-2012 05:41 AM |
![]() |
excelledsoftware | Excel Programming | 1 | 07-17-2012 04:22 AM |
![]() |
Jirik61 | Excel Programming | 3 | 07-13-2012 01:40 PM |