Dear Team,
I have macro workbook , i would like a script to autocapitalize every word typed in excel.
Kindly help.
Dear Team,
I have macro workbook , i would like a script to autocapitalize every word typed in excel.
Kindly help.
Copy this code into ThisWorkbook module of your workbook.
Please Login or Register to view this content.
Dear SIr,
I pasted the same in the module of my worksheet but nothing happened, it is not capitalizaing after entrying values in the cell
Past into ThisWorkbook module (not Worksheet module).
If you want apply on only one sheet, copy code into module of that worksheet and replace the line
by this linePlease Login or Register to view this content.
Please Login or Register to view this content.
hi
i tried this below line as i want change in one sheet only , however its is only capitalizing one Alphabet , i want all word to be in uppercase
Private Sub Worksheet_Change(ByVal Target As Range)
I'm sorry, this is my mistake. Please retry with this.
Please Login or Register to view this content.
thx worked fine
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks