amoverton2
Board Regular
- Joined
- May 13, 2021
- Messages
- 77
- Office Version
- 2016
- Platform
- Windows
Still learning VBA...
I have userform with a textbox to enter LAST,FIRST NAME. I want no spaces between the last name and first name so it matches with other data in the workbook for other things.
Examples: Good: JORDAN,MICHAEL, Bad: JORDAN, MICHAEL.
I am looking for a VBA code that if a person does enter JORDAN, MICHAEL, an event (AfterUpdate or Exit) removes the space between last and first name. I figured out how to convert it to all uppercase if someone puts it in lowercase but now I need to remove any spaces. Everything I've seen is either beginning or end of the text string, nothing in the middle. If there is a thread out there please point me there and I'll close this one up quickly.
Thanks for your time.
I have userform with a textbox to enter LAST,FIRST NAME. I want no spaces between the last name and first name so it matches with other data in the workbook for other things.
Examples: Good: JORDAN,MICHAEL, Bad: JORDAN, MICHAEL.
I am looking for a VBA code that if a person does enter JORDAN, MICHAEL, an event (AfterUpdate or Exit) removes the space between last and first name. I figured out how to convert it to all uppercase if someone puts it in lowercase but now I need to remove any spaces. Everything I've seen is either beginning or end of the text string, nothing in the middle. If there is a thread out there please point me there and I'll close this one up quickly.
Thanks for your time.