by Paul Kelly | | Strings and Text, VBA Language
Welcome to this article on the VBA Left, Right and Mid string functions. In this post, I will show you when to use these functions and equally importantly when to avoid using them. If you use them for the wrong type of tasks(i.e. extracting from variable strings), you...
by Paul Kelly | | Vault Video, VBA Language
Webinar Number: W0033 The Dim statement is a fundamental part of VBA. Everything you do in VBA involves the Dim statement. Therefore it is vital to understand Dim as everything else you do will be easier to understand. This webinar features: Live Excel VBA Coding....
by Paul Kelly | | VBA Language
The Select Case statement is an alternative way to write If/ElseIf statements. You will find a Select Case statement equivalent in most popular programming languages. In many languages, the equivalent statement is the Switch statement. For example, the languages Java,...
by Paul Kelly | | UserForms, VBA Language
The VBA MsgBox function is used to display messages to the user in the form of a message box. We can configure the message box to provide the user with a number of different buttons such as Yes, No, Ok, Retry, Abort, Ignore and Cancel. The MsgBox function will...
by Paul Kelly | | VBA Language
“One man’s constant is another man’s variable.” – Alan Perlis This post provides a complete guide to using the VBA Dim statement. The first section provides a quick guide to using the Dim statement including examples and the format of the Dim...
by Paul Kelly | | Vault Video, VBA Language
Webinar Number: W0012 This webinar provides an in-depth guide to using the For Loop in VBA. It is based on this article on the For Loop. Related Links The Ultimate VBA Tutorial Part One The VBA Dictionary The VBA Collection The ArrayList(Vault Only) (NOTE:...