ValidateVBName – Check a variable’s or procedure’s name

' Return True if a string is a valid name for a Visual Basic variable or ' procedure.' This function turns to be useful when writing add-ins that generate code.' The optional argument specifies whether the dot character is accepted.Function ValidateVBName(ByVal VBName As String, Optional ByVal acceptDots As _    Boolean = False) As Boolean    Dim i As Long    ' reject null strings or strings that are too long    If VBName Is Nothing OrElse VBName.Length = 0 OrElse VBName.Length > 255 _        Then        Exit Function    ElseIf VBName.IndexOf("..") >= 0 Then        ' two consecutive dots aren't valid        Exit Function    End If    ' create the regular expression    ' note that ^ is the beginning of string, $ is end of string    Dim pattern As String = "^[A-Z_][A-Za-z0-9_]*$"    If acceptDots Then        pattern = "^[A-Z_][A-Za-z0-9_.]*$"    End If    Dim re As New Text.RegularExpressions.Regex(pattern, _        Text.RegularExpressions.RegexOptions.IgnoreCase)    ' return True if it is a perfect match    Return re.IsMatch(VBName)End Function

Share the Post:
Share on facebook
Share on twitter
Share on linkedin


The Latest

your company's audio

4 Areas of Your Company Where Your Audio Really Matters

Your company probably relies on audio more than you realize. Whether you’re creating a spoken text message to a colleague or giving a speech, you want your audio to shine. Otherwise, you could cause avoidable friction points and potentially hurt your brand reputation. For example, let’s say you create a

chrome os developer mode

How to Turn on Chrome OS Developer Mode

Google’s Chrome OS is a popular operating system that is widely used on Chromebooks and other devices. While it is designed to be simple and user-friendly, there are times when users may want to access additional features and functionality. One way to do this is by turning on Chrome OS

homes in the real estate industry

Exploring the Latest Tech Trends Impacting the Real Estate Industry

The real estate industry is changing thanks to the newest technological advancements. These new developments — from blockchain and AI to virtual reality and 3D printing — are poised to change how we buy and sell homes. Real estate brokers, buyers, sellers, wholesale real estate professionals, fix and flippers, and beyond may