hi there

need some help with the following

i have setup an userform and then wrote the code to fill the last empty cell and then to enter the value from the userform into the cell

but i would like that value to be converted into 'proper' text, i can do it direct in the worksheet for example by entering =proper(a1) but not sure how to write the code

thanks