Category Archives: VBA Code MS Excel

Early and Late Binding

Good article on Early and Late Binding MSDN Early and Late binding Coding can appear very complicated sometimes but to simplify the difference in terms of implementation this line is very clear; The only difference between early binding and late … Continue reading

Posted in All, MS Access, VBA Code MS Access, VBA Code MS Excel | Comments Off on Early and Late Binding

Scramble the values of individual cells in an Excel Spreadsheet

Just out of curiosity I went off and had a look for a function that does the same for excel spreadsheets as my previous post did for databases. Here’s a function that will work. Public Function Scramble(Optional ByRef UserText As … Continue reading

Posted in All, Excel, VBA Code MS Excel | Comments Off on Scramble the values of individual cells in an Excel Spreadsheet