Edit single character within a variable

[rickdogg03]

The solution to this is probably quite easy, however, I'm new to the
whole world of Excel Programming with VBA. Here's the situation:

User makes an input. The input is always in the same format and is
assigned to a variable called AppID. The format of the input is
xxx-xxxxx-xx, where x can be any combination of letters and numbers.
How do I do this: If the 5th character from the left of AppID is equal
to 0, then I want to create a new variable, called AppID2, but the 5th
character of AppID2 will be changed from 0 to V.

Any help is much appreciated!

Rick

 

[LenB]

Try this.

If Mid(AppID, 5, 1) = "0" Then
AppID2 = AppID
Mid(AppID2, 5, 1) = "V"
End If

 

[rickdogg03]

Thanks LenB! I didn't even know about the built-in Mid function.