Code Snippets and Tips for Visual Basic (VB/VBA)

VB Code Snippets

• Sort a collection using HeapSort
• Sort an array using HeapSort
• Get the memory address of a VB variable
• "Soundex" function in VB
• Format roman numerals
• Find the IP addresses of the local computer
• Excel "NORMSINV" worksheet function in VB
• How to use Row.AutoFit for merged Excel cells
• Base64 encoder/decoder module

VB Tips

• How to create a self-signed certificate that can be used to sign MS-Office VBA projects (Excel/Word macros) on multiple computers.
• How to avoid a broken reference to the ADOX library (msadox.dll)
• How to avoid error 3734 ("The database has been placed in a state by user <name> on machine <name> that prevents it from being opened or locked")