#1
|
|||
|
|||
Proper Text Format
What If I want to Capitalize First letters in 2 Cells that are A8 and A10 only
What would be the Macro/Code ? |
#2
|
||||
|
||||
Why not just type the capitals? A lot less mucking around than using macros or formulae!
As for the macro, you could use: Code:
Private Sub Worksheet_Change(ByVal Target As Excel.Range) If Intersect(Target, Range("A8")) Is Nothing Then If Intersect(Target, Range("A10")) Is Nothing Then Exit Sub End If Target.Value = WorksheetFunction.Proper(Target.Text) End Sub
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Find text, format part of text in italic | d4okeefe | Word VBA | 18 | 06-30-2022 11:35 PM |
Macro to find text in between two characters and then format selected text? | qcom | Word | 5 | 02-19-2015 11:23 PM |
Proper way to calculate tables in document | rmw85 | Word Tables | 3 | 10-11-2012 06:02 PM |
Proper Excel Table of Contents (ToC) | judicial85 | Excel | 1 | 10-23-2011 01:35 PM |
Objective: Automatically export email text,attachment text to DB friendly format | SilentLee | Outlook | 0 | 11-14-2010 02:45 PM |