Recording macros in VBA – A great way of learning

Sometimes when you are working with some VBA module of yours you wonder how to, for example, bolden the text in a cell or how to add borders to a…Sometimes when you are working with some VBA module of yours you wonder how to, for example, bolden the text in a cell or how to… Continue Reading


Formatting cells with VBA

Formatting cells in VBA isn’t that hard and I thought I’d just show an example of how to format 5 cells in a cross form. If you need help creating…Formatting cells in VBA isn’t that hard and I thought I’d just show an example of how to format 5 cells in a cross form. If… Continue Reading


Using collections in VBA

3 Comments

When working in languages such as Java or C#, collections are a very basic part of your toolbox. The reason you want to work with collections rather then arrays is…When working in languages such as Java or C#, collections are a very basic part of your toolbox. The reason you want to work with collections… Continue Reading


Your first VBA module

1 Comment

When using VBA extensivly it is a good idea to know how to use VBA. VBA means Visual Basic for Application and can be used to automate functions that are…When using VBA extensivly it is a good idea to know how to use VBA. VBA means Visual Basic for Application and can be used to… Continue Reading