Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
[blue]Public Function AbbrevState(State)
If State = "New York" Then
AbbrevState = "NY"
ElseIf State = "Georgia" Then
AbbrevState = "GA"
ElseIf State = "West Virginia" Then
AbbrevState = "WV"
[green]'
'Other States for as many as you have.
'[/green]
Else
[green]'Return the same if state fails to compare.[/green]
AbbrevState = State
End If
End Function[/blue]
[blue]AbbrevState([State])[/blue]
[blue]Option Compare Database
[purple]or[/purple]
Option Compare Text[/blue]