|
|
|
|
#1
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
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
|
|
|
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 |
Windows 7 32bit 
Office 2010 32bit
Hybrid Mode