VBA – Split Function

  • Post author:
  • Post category:VBA
  • Post comments:0 Comments

A Split Function returns an array that contains a specific number of values split based on a delimiter. Syntax Split(expression[,delimiter[,count[,compare]]]) Parameter Description Expression − A required parameter. The string expression that…

Continue ReadingVBA – Split Function

VBA – LBound Function

  • Post author:
  • Post category:VBA
  • Post comments:1 Comment

The LBound Function returns the smallest subscript of the specified array. Hence, LBound of an array is ZERO. Syntax LBound(ArrayName[,dimension]) Parameter Description ArrayName − A required parameter. This parameter corresponds to…

Continue ReadingVBA – LBound Function

VBA – Time Value Function

  • Post author:
  • Post category:VBA
  • Post comments:0 Comments

The TimeValue Function converts the given input string to a valid time. Syntax TimeValue(StringTime) Example Add a button and add the following function. Private Sub Constant_demo_Click() msgbox(TimeValue("20:30")) msgbox(TimeValue("5:15")) msgbox(TimeValue("2:30:58")) End…

Continue ReadingVBA – Time Value Function

C# – Nullables

  • Post author:
  • Post category:C#
  • Post comments:2 Comments

C# Nullables provides special data types, the nullable types, to which you can assign a normal range of values as well as null values. For example, you can store any value from…

Continue ReadingC# – Nullables