| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Proper Case Odditiy
Jim Rech wrote
Try: StrConv("don't",vbProperCase) in VBA Thank you! I was having the same problem converting text from a userform using Payee1 = Application.Proper(UserForm1.TextBox1.Text) I can now use Payee1 = StrConv(UserForm1.TextBox1.Text, vbProperCase) and input like sam's club no longer comes out Sam'S Club. -- David |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change from upper case to proper case in excel 2002 | Excel Discussion (Misc queries) | |||
| excel'03 how to convert a column from upper case to proper case | Excel Discussion (Misc queries) | |||
| Excel: How do I change all upper case ss to proper case? | Excel Worksheet Functions | |||
| Changing Upper case to Proper Case | Excel Worksheet Functions | |||
| Proper Case with . | Excel Programming | |||
Hybrid Mode
