sheet tab
Did you put in the sheet module or a regular module.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"nflor009" wrote in message
...
Thanks for responding to this, Don. I did exactly what you said, and the
cells acted no differently. I typeed a word into them and the first letter
is
still not capitalized. I even tried it again leaving c2:c12 in there and
those cells didn't respond either. Am I supposed to do something to apply
the
changes after pasting the code? I also tried it with something in that
range
of cells before adding the code to see if it would work....but it didn't.

"Don Guillett" wrote:

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