A Tutorial Website with Real Time Examples
The UBound function in VBA returns the highest subscript for the specified dimension in the given array. Syntax
|
0 1 2 |
UBound (ArrayName, [Dimension]) |
Parameter ArrayName (required) – This parameter represents an array for which you want to find the highest subscript. Dimension (optional) – …
The Split function in VBA is used to split a string into several substrings and return a one-dimensional array of substrings. Syntax
|
0 1 2 |
Split (Expression, [Delimiter], [Limit], [Compare]) |
Parameter Expression (required) – This parameter represents a text string that you want to split. Delimiter (optional) …
The LBound function in VBA returns the lowest subscript for the specified dimension in the given array. Syntax
|
0 1 2 |
LBound (ArrayName, [Dimension]) |
Parameter ArrayName (required) – This parameter represents an array for which you want to find the lowest subscript. Dimension (optional) – …
The Join function in VBA is used to join an array of substrings and return them all as a single string. Syntax
|
0 1 2 |
Join (SourceArray, [Delimiter]) |
Parameter SourceArray (required) – This parameter represents an array of substrings that you want to join. Delimiter …
VBA Filter Function: The Filter function in VBA returns a subset for the given string array, based on specified criteria. Syntax
|
0 1 2 |
Filter (SourceArray, Match, [Include], [Compare]) |
Parameter SourceArray (required) – This parameter the array of Strings that you want to filter. Match (required) – …
VBA Array Function: The Array function in VBA generates an array containing the given set of values. Syntax
|
0 1 2 |
Array (Arglist) |
Parameter Arglist (required) – This parameter the list of values that you want to make up the array wherein the values …
VBA Sqr Function: The Sqr function in VBA returns the square root for the specified number. Syntax
|
0 1 2 |
Sqr (Number) |
Parameter Number (required) – This parameter represents a positive numeric value that you want to calculate the square root. Return This function …
VBA Tan Function: The Tan function in VBA returns the tangent for the specified angle in radians. Syntax
|
0 1 2 |
Tan (Number) |
Parameter Number (required) – This parameter represents the angle supplied in radiant that you want to calculate the tangent of. Return …
The Ionic Framework is based on the AngularJS framework that permits a programmer to use a combination of many other programming languages, like HTML5, CSS, and JavaScript. Some of the important features of the Ionic Framework are as follows: Cross-Platform: …
VBA Sin Function: The Sin function in VBA returns the sine value for a supplied angle. Syntax
|
0 1 2 |
Sin (Number) |
Parameter Number (required) –This parameter represents the angle (in radians) to calculate the sine value. Return This function returns the sine value …
The Apache Cordova plugin helps to displays and hides a splash screen during the application launch. The Ionic Splash Screen is similar to a home page on a website. The ionic splash screen is a graphical control element. It consists …
VBA Sgn Function: The Sgn function in VBA returns an integer (+1, 0, or -1), stating the arithmetic sign for the specified number. Syntax
|
0 1 2 |
Sgn (Number) |
Parameter Number (required) –This parameter represents the number that you want the arithmetic sign of. …
The Ionic popover is a small dialog box that displays at the top of the screen. It can be used for anything, but it is usually used for a button, an action, a pointer, which is similar to the ionic …
The latest version (ionic 4) of the ionic framework, no longer limited to the angular. In Ionic 4, you can create an ionic project in different front-end frameworks such as Vue.js, React.js, and Angular. The angular application contains an important …
VBA Round Function: The Round function in VBA rounds a number to a specified number of decimal places and returns the number. Syntax
|
0 1 2 |
Round (Number, [NumDigitsAfterDecimal]) |
Parameter Number (required) –This parameter represents a numeric value one wants to round. NumDigitsAfterDecimal (optional) – This …
VBA Rnd Function: The Rnd function in VBA returns a random number that is greater than or equal to (>=) 0 and is less than (<) 1. Syntax
|
0 1 2 |
Rnd ([Number]) |
Parameter Number (optional) –This parameter represents a numeric value. It can …
In today’s time, the mobile location plays an essential role in the mobile application. The Ionic Cordova geolocation plugin provides information about the location of the device, like as latitude and longitude. The most common sources to get the location …
VBA Log Function: The Log function in VBA returns the natural logarithm for the specified number. Syntax
|
0 1 2 |
Log (Number) |
Parameter Number (required) –This parameter represents a positive numeric value that you want to find the natural logarithm of. Return This function …
Hybrid mobile applications can make very quickly, but sometimes it becomes a challenge to get the features that access the hardware such as GPS, storage, file storage, cameras, and networks. Cordova offers plugins to build relationships to use them with …
VBA INT Function: The INT function in VBA rounds the given supplied number down and returns an integer value. The positive numbers are rounded to zero, and the negative numbers are rounded away from zero. Syntax
|
0 1 2 |
Int (Number) |
Parameter Number (required) –This parameter represents the number …