rhombus4
Well-known Member
- Joined
- May 26, 2010
- Messages
- 586
- Office Version
- 365
- 2016
- Platform
- Windows
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
B2 becomes john smith
B2 becomes John Smith
Even tried
That becomes John Smith
I want B2 to become John Smith
Also is ther a difference when transferring if you use
= Textbox1
= Textbox1.value
= Textbox1.text
VBA Code:
Range ("B2") = application.worksheetfunction.proper(textbox1.value)
Range ("B2") = application.worksheetfunction.trim(textbox1.value)
B2 becomes john smith
VBA Code:
Range ("B2") = application.worksheetfunction.trim(textbox1.value)
Range ("B2") = application.worksheetfunction.proper(textbox1.value)
B2 becomes John Smith
Even tried
VBA Code:
Range ("B2") = application.worksheetfunction.proper(trim(textbox1.value))
That becomes John Smith