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 add borders to a selection….
Read the rest...Category Archives: VBA
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 you need help creating a…
Read the rest...Using collections in VBA
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 rather then arrays is that…
Read the rest...Your first VBA module
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 automate functions that are hard…
Read the rest...