Hi

Try something along the lines of

mycell.value = worksheetfunction.proper(mytextbox.text)


rylo