VBA中实现SortedList早期绑定需启用的引用名称是什么？

Hey there, great question—this is a common switch for VBA folks looking to leverage intellisense and compile-time error checking, and yes, plenty of developers have successfully made this conversion.

所需的引用名称 #

To use early binding for SortedList, you need to enable the "Microsoft .NET Framework Class Library" reference in the VBA Editor. Here's the step-by-step:

• Open the VBA Editor (press Alt+F11 in Excel/Word/etc.)
• Go to the Tools menu → References
• Scroll through the list until you find an entry named something like "Microsoft .NET Framework X.X Class Library" (X.X is the version number, e.g., 4.8 or 4.7.2)
• Check the box next to it and click OK

If you don’t see it listed, you can manually browse for the core file:

• Click the Browse button in the References dialog
• Navigate to C:\Windows\Microsoft.NET\Framework\v4.0.30319\ (for 32-bit Office) or C:\Windows\Microsoft.NET\Framework64\v4.0.30319\ (for 64-bit Office)
• Select mscorlib.dll and add it—this will populate the reference in your list.

转换可行性 #

Absolutely, this conversion works perfectly once the reference is set up. After enabling it, your early binding code:

Dim myList As New SortedList

will behave exactly like your late-binding code, but with key benefits:

• Real-time intellisense for SortedList methods/properties (no more guessing syntax!)
• Compile-time error checking (catches typos or invalid method calls before running the code)
• Slightly faster execution compared to late binding

Just a quick heads-up: If you share your VBA project with others, make sure their machines have the same (or compatible) .NET Framework version installed—otherwise they’ll get a missing reference error. Sticking to a widely used version like 4.0 or 4.8 minimizes compatibility headaches.

内容的提问来源于stack exchange，提问作者Erik på kontoret