string manipulation vba

[lezawang]

Hi

I wrote a code to ask user to enter first and last name and then the code will msgbox fullname. Now I want to improve the code. I want to msgbox the first letter for the first name then last name. So later I can msgbox the email address.

For example, if user enter John Smith

I want to msgbox --> JSmith

then later I will do

> your email address is JSmith@abc.com

Thank you very much.

Sub myname()
    Dim first As String
    Dim last As String
    Dim full As String
    first = InputBox("enter first name")
    last = InputBox("enter last name")
    full = first & "  " & last
    MsgBox "your full name is >> " & full
End Sub

 

[Fluff]

How about

    MsgBox "your full name is >> " & Left(first, 1) & last

 

[lezawang]

Thank you very much. That resolve the issue. Just one more question. What do you call Left() function here? Is it VBA function or Excel sheet function? Thank you once again

 

[Joe4]

What do you call Left() function here? Is it VBA function or Excel sheet function?

They just happen to be called the same thing and work the same way in both Excel and VBA.
So, it is BOTH an Excel and a VBA function.

 

[Fluff]

Further to Joe's comment, in general if a function is preceded with Application or WorksheetFunction then it's an xl function, otherwise it's VBA