1. B

    VBA to capitalize every proper word in a sentence

    Is there any way using VBA to capitalize every proper word in a sentence? For example for the sentence: Beginning in 1910, the automobile industry sprang up in Detroit with 125 different auto companies. The rise of the city’s automobile industry spawned an upward movement of population and...
  2. P

    Attribute Issues

    Hi! Whenever I dim an attribute to "shape" it makes it captialize weird. Say I type "dim shp as shape" it returns this "Dim shp as sHape" Anyone know why it would capitalize the "H"?
  3. B

    How to capitalize any text in cell?

    Hello all, How do you make a cell or whole selected area/spreadsheet automatically capitalize any inserted text to CAPITAL letters? Thank you. Much appreciated in advance.
  4. E

    Run time error from code capitalizing all cells in multiple ranges

    I implemented the following VB code to my excel sheet where I want all input within multiple ranges forced to capital letters. Code is as follows: Private Sub Worksheet_Change(ByVal Target As Range) If Not (Application.Intersect(Target, Range("E9:CQ19, E22:CQ32, E35:C45")) Is Nothing) Then...
  5. K

    Code or formula for capitalizing, excluding acronyms

    Hi all, I am looking for vba code or a macro the will capitalize the first letter of each word, and does not make any changes to acronyms. I am aware of the proper function, however it changes the letters in an acronym to lower case, except for the first. Is there a way to do this, either by...
  6. C

    Capitalize only the first letter in text string

    In Excel 2003, I am referencing a text string and would like to return the text string with only the first letter capitalized. The PROPER function does not do this, as it capitalizes the first letter of every word. The formula below does however perform this, but I would like to write it as a...

Some videos you may like

This Week's Hot Topics