Macros Required to Auto capitalize every word typed in cells

[sparkerk5]

Dear Team,

I have macro workbook , i would like a script to autocapitalize every word typed in excel.

Kindly help.

[huuthang_bd]

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.

[sparkerk5]

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

[huuthang_bd]

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

Please Login or Register  to view this content.

by this line

Please Login or Register  to view this content.

[sparkerk5]

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)

[huuthang_bd]

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

I'm sorry, this is my mistake. Please retry with this.

Please Login or Register  to view this content.

[sparkerk5]

thx worked fine