Function Math Miscellaneous Class

TelevisionFrequency

Return the frequency in MHz (Megahertz) assigned to some part of the television transmission for a specific channel. For example, return the frequency of the sound portion of the cable television channel 53.

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.