change this "Smith, John" to this "John Smith" with VBA

[Mr_Ragweed2]

Hello and sorry for the crappy subject header. As stated i need to change "Smith, John" to "John Smith" but the name could be "Experticus, Vba" to "Vba Experticus" - dynamic length of each. I assuming it has something to do with" LEN", but that is one area that i cannot get to make sense to me - the code just looks like a bunch of commas.
I asked a very follow up question in one of my other posts but i thought it should probably be a different post since it was not my original question. (I apologize if that breaks the duplicate post rules. If so, please refer to this post instead.) vba to retrieve dynamic username for file save

Thanks in advance!

 

[johnnyL]

What line of VBA code is yielding the result of 'Smith, John' ?

Is 'Smith, John' being saved into a variable?

 

[Mr_Ragweed2]

It is actually the result of a username lookup. Right now as

MsgBox Application.UserName

but i'm sure i will need to paste that result in a cell and then perform the operation i need.

 

[johnnyL]

Assuming you will have ', ' in the result of Application.UserName ... Try the following:

    Dim UsernameReversed    As String
    Dim UsernameStringArray As Variant
'
    UsernameStringArray = Split(Application.UserName, ", ")
'
    UsernameReversed = UsernameStringArray(1) & " " & UsernameStringArray(0)

That should put 'John Smith' into the variable named UsernameReversed

 

[Mr_Ragweed2]

Oh wow. That's so nice!
Thank you so very much.

I think i can handle the rest from here as i need to concatenate a few things onto it.

 

[johnnyL]

Glad to help.