VBA trim and proper

[rhombus4]

If textbox1 is. john smith

I want B2 to become John Smith

Also is ther a difference when transferring if you use

= Textbox1
= Textbox1.value
= Textbox1.text

Range ("B2") = application.worksheetfunction.proper(textbox1.value)
Range ("B2") = application.worksheetfunction.trim(textbox1.value)

B2 becomes john smith

Range ("B2") = application.worksheetfunction.trim(textbox1.value)
Range ("B2") = application.worksheetfunction.proper(textbox1.value)

B2 becomes John Smith

Even tried

Range ("B2") = application.worksheetfunction.proper(trim(textbox1.value))

That becomes John Smith

 

[Marc L]

Also is ther a difference when transferring if you use

No as it's just an obvious logic error in your second codeline …​

 

[rhombus4]

????????