Proper Text Format

sufian,naeem · #1 05-05-2014, 12:48 AM

What If I want to Capitalize First letters in 2 Cells that are A8 and A10 only

What would be the Macro/Code ?

macropod · #2 05-05-2014, 05:59 AM

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

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