attempting to add multiple values into left footer

[lizardking365]

hi everyone, first post here, i have a very basic knowledge to excel and vb but i've done ok up to this point.

basically, i am trying to create an excel template, this template will have a userform that users will enter certain details, e.g. initials/firstname and also version control (i.e. v1.0.0) which will then be inputted into the left footer box.

i have written the vb script that will write to that footer area but because it is multiple textboxes/values i don't know the correct way in which to add together as one value them.

in the userform there are 4 textboxes (txtDate, txtVersion, txtName, txtSurname). i need the footer to look as follows:

Copyright © / txtDate / txtName txtSurname / txtVersion

the script for adding the data is as below:

Please Login or Register  to view this content.

I hope this makes sense, any help would be gratefully received.

[protonLeah]

It might look something like:

Please Login or Register  to view this content.