Concatname User Defined Function

I am trying to create a custom concatenate function specifically for people's names, tho i have zero knowledge about programming and i literally have no idea what im doing, i made this code purely out of google searching and instinct alone 😂,

    Dim xFirstRef As String      Dim xSecondRef As String      Dim xMiddleIn As String      Dim xThirdRef As String      Dim xFullName As String            If FirstName = "" Then        xFirstRef = ""        Else:         xFirstRef = StrConv(FirstName, vbProperCase)       End If            xMiddleIn = Left(MiddleInitial, 1) & "."            If MiddleInitial = "" Then       xSecondRef = ""        Else:        xSecondRef = StrConv(xMiddleIn, vbProperCase)       End If            If LastName = "" Then        xThirdRef = ""        Else:         xThirdRef = StrConv(LastName, vbProperCase)       End If            CONCATNAME = xFirstRef & " " & xSecondRef & " " & xThirdRef          End Function  

My problem is i have no idea why it isn't working and how can i make it work, please Enlighten this humble peasant.

https://stackoverflow.com/questions/66094741/concatname-user-defined-function February 08, 2021 at 09:07AM