Use IsMissing: If IsMissing(arg) Then MsgBox “Parameter arg not passed” End If However, if I remember correctly, this doesn’t work when giving a default for the argument, and in any case it makes using the default argument rather redundant.
for VB: vbCrLf or vbNewLine for VB.NET: Environment.NewLine or vbCrLf or Constants.vbCrLf Info on VB.NET new line: http://msdn.microsoft.com/en-us/library/system.environment.newline.aspx The info for Environment.NewLine came from Cody Gray and J Vermeire
Take a look here: Edit: The referenced source (allexperts.com) has since closed, but here are the relevant author comments: There are many algorithms available on the web for sorting. The most versatile and usually the quickest is the Quicksort algorithm. Below is a function for it. Call it simply by passing an array of values … Read more
There’s no reason to use set unless referring to an object reference. It’s good practice to only use it in that context. For all other simple data types, just use an assignment operator. It’s a good idea to dim (dimension) ALL variables however: Examples of simple data types would be integer, long, boolean, string. These … Read more
In both Visual Basic 6.0 and VB.NET you would use: Exit For to break from For loop Wend to break from While loop Exit Do to break from Do loop depending on the loop type. See Exit Statements for more details.
For nearly all programming purposes, VBA and VB 6.0 are the same thing. VBA cannot compile your program into an executable binary. You’ll always need the host (a Word file and MS Word, for example) to contain and execute your project. You’ll also not be able to create COM DLLs with VBA. Apart from that, … Read more
Yes. Set a reference to MS Scripting runtime (‘Microsoft Scripting Runtime’). As per @regjo’s comment, go to Tools->References and tick the box for ‘Microsoft Scripting Runtime’. Create a dictionary instance using the code below: Set dict = CreateObject(“Scripting.Dictionary”) or Dim dict As New Scripting.Dictionary Example of use: If Not dict.Exists(key) Then dict.Add key, value End … Read more
Dim originally (in BASIC) stood for Dimension, as it was used to define the dimensions of an array. (The original implementation of BASIC was Dartmouth BASIC, which descended from FORTRAN, where DIMENSION is spelled out.) Nowadays, Dim is used to define any variable, not just arrays, so its meaning is not intuitive anymore.