Right click sheet tabview codecopy/paste thischange range to suit.

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("c2:c12")) Is Nothing _
Or Target.Cells.Count 1 Then Exit Sub
Application.EnableEvents = False
Target.Value = WorksheetFunction.Proper(Target)
Application.EnableEvents = True
End Sub
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"nflor009" wrote in message
...
That's a bit over my head. I opened VBA from the spreadsheet, selected the
sheet I was working on, but have no clue what to put in the window that
opened up after that.

I'd greatly appreciate if someone could tell me what to insert into that
window that might work for a range of cells in a column where I want the
first letter of whatever goes in that cell to be capitalized.

Maybe it's silly but the person inputting the data hates using her shift
key, so everything is in small letters and when I need to export certain
cells into the salutation of group merge letter in Word, I don't want to
have
to correct the output.


"David Biddulph" wrote:

Formatting won't do that.
You might want to investigate a VBA solution.
--
David Biddulph

"nflor009" wrote in message
...
A follow up question on this topic:

How do I format a cell so that whatever is entered has the first letter
capitalized, as in a proper name. I tried the =PROPER(cell) but a
formula
doesn't work since you delete it when you type into that cell, so I
need
formatting, not a formula.

"rodchar" wrote:

hey all,
is there an easy way to capitalize just the first letter in a column
and
leave the rest as is?

for example,
pubID -- PubID

thanks,
rodchar