I presume you are doing this for a class project.
First, change the entire string you get to lower case using the LCase function. Then change the first character in the string to uppercase using the UCase function. Then find the location of the blank separating the two parts of the name using the InStr function and change the following character to uppercase. You use the Mid statement/function to change a character within a string.
Hope this helps, and happy programming.