This documentation was styled with a demo skin from the Premium Pack 4 add-on for Help & Manual. The contents of the skin are encrypted and not configurable. You can only publish HM projects with this skin. You cannot edit it or change it.
This version is copyright and may only be used for local testing purposes. It may not be distributed.
Please purchase the full version of the Premium Pack to get the configurable skins and remove this notice. The package will also include the Toolbox configuration utility for Premium Pack skins.
Description
Check whether a string contains a script variable name mark, $ followed by variable name, and substitute with variable value.
If variable name mark will be found, its position will be expanded (substituted) using current variable content.
Syntax
s = EXPAND$(sMainString)
Returns
String
Parameters
Name |
Type |
Optional |
Meaning |
sMainString |
String |
No |
Main string to check for variable names |
Remarks
sMainString will be searched for $ variable placeholders.
Variable placeholders must be followed by the name of the variable to be expanded. See example below.
Restrictions
Only simple numeric and string variables are supported.
No arrays, no UDT elements are supported.
See also
Examples
Dim MyLong As Long Value 123
Dim MyString As String = "Value of MyLong is: $MyLong"
MsgBox 0, EXPAND$(MyString)