Signature (Visual Basic / VBA)
Public Function TelevisionFrequency( _
ByVal vChannel As Variant _
, Optional ByVal vCable As Variant _
, Optional ByVal vSignalType As Variant _
) As Variant
Code Examples
TelevisionFrequency(2, False, "Sound") = 59.75
TelevisionFrequency(2, True, "Sound") = 59.75
TelevisionFrequency(2, False, "Min") = 54
TelevisionFrequency(2, False, "Max") = 60
TelevisionFrequency(45, False, "Sound") = 661.75
TelevisionFrequency(45, True, "Sound") = 353.75
CO: Color Carrier
MI: Minimum Frequency
MA: Maximum Frequency
PI: Picture (video) Carrier
SO: Sound (audio) Carrier
Parameters
| Parameter | Description |
|---|---|
| vChannel | The television channel whose frequency will be returned. Function returns Null if vChannel is Null or cannot be fixed up to a number. Function returns Null if vChannel is not the number of a valid television channel. |
| vCable | True if the cable television frequency should be returned, or False if the broadcast television frequency should be returned. vCable defaults to False (the broadcast TV frequency will be returned) if it is missing or Null or cannot be fixed up to a number. The cable and broadcast frequencies are different for most of the channels. |
| vSignalType | The specific portion of the television broadcast whose frequency will be returned. vSignalType defaults to "Min" if it is missing or Null or cannot be fixed up to a String. vSignalType must be a string that begins with one of the words in the following table. Function returns Null if vSignalType does not begin with the letters "CO", "MI", "MA", " PI " or "SO". The match is case-insensitive, so for example, "MIN" and "min" would both match "Min". |
Notes & Version History
| Note | Function recognizes channels numbers of the form "T-1", "T-12", etc. Any such channel number strings will have their leading "T-" portion removed. |