Signature (Visual Basic / VBA)
Public Function RulerStringWithTabStops( _
ByVal vLength As Variant _
, Optional ByVal vStyle As Variant _
, Optional ByVal vTabStop As Variant _
) As Variant
Code Example
? RulerStringWithTabStops(30, 1, 8)
12345678^0123456^8901234^67890
? RulerStringWithTabStops(30, 2, 8)
000000000111111111122222222223
12345678^0123456^8901234^67890
? RulerStringWithTabStops(30, 3, 8)
000000000000000000000000000000
000000000111111111122222222223
12345678^0123456^8901234^67890
? RulerStringWithTabStops(30, 4, 8)
----+---^|----+-^--|----^----|
? RulerStringWithTabStops(30, 5, 8)
5 10 15 20 25 3
----+---^|----+-^--|----^----|
Parameters
| Parameter | Description |
|---|---|
| vLength | The length of each line with the "ruler" string to be created. Function returns Null if vLength is Null or cannot be fixed up to a number. |
| vStyle | A number describing the style of the ruler string to be created. vStyle defaults to 3 (three) if it is missing or Null or cannot be fixed up to a number. Function returns an empty string if the style is not a number between 1 and 5. |
| vTabStop | The number of characters between each tab stop, The tab stop (if any) is indicated by the caret character (^) within the result string. vTabStop defaults to 0 (zero; there are no tab stops) if it is missing or Null or cannot be fixed up to a number. |