2 Texboxes and One Cell

I wanted to know if its possible to have two textboxes in a userform that contain first name (textbox1) and last name (textbox2). In sheet 1 have the values of the textboxes in one cell. In A1 the full name would appear.

I looked on different sites and couldn't find an answer. If someone can direct me to a solution that would be very appreciated.

Thank you.

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

Hope this helps.

If you need any further information, please feel free to ask further

However

If this takes care of your needs, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody!
Also
If you are satisfied by any members response to your problem please consider using the scales icon top right of thier post to show your appreciation.

I thought that would do the trick but no...

Maybe I'm putting it somewhere it doesn't belong.

First I tried in the Userform_Change.

Then Module.