Excel: Automatic Conditioning of Text Cell Entries

[sten28]

Hi there,

To be brief, I'm using Microsoft Excel 2003 and am trying to achieve the following:

* a user enters text into a cell

* Excel will automatically format the cell into Title Case

Simple what I want to achieve, but it's proving harder than I thought it'd be! Any advice?

 

[SkipVought]

Hi,

This is not a FORMAT. It is changing the text value. It can only be done EITHER in another cell using the UPPER function of via VBA code using the Worksheet_Change event, in which case, please repost in VBA Visual Basic for Applications (Microsoft) Forum707.

Skip,
[sub]
[red][/red]
[/sub]

 

[sten28]

Is there any way this can be done without VB? I thought it would've been a conditional format.

 

[SkipVought]

Again, this is NOT A FORMAT ISSUE.

It is actually changing VALUES.

Skip,
[sub]
[red][/red]
[/sub]

 

[sten28]

No worries, I'll run it past the VB crew, cheers