Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel: Automatic Conditioning of Text Cell Entries

Status
Not open for further replies.

sten28

Technical User
Apr 9, 2007
20
AU
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?
 




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]
[glasses] [red][/red]
[tongue][/sub]
 
Is there any way this can be done without VB? I thought it would've been a conditional format.
 




Again, this is NOT A FORMAT ISSUE.

It is actually changing VALUES.

Skip,
[sub]
[glasses] [red][/red]
[tongue][/sub]
 
No worries, I'll run it past the VB crew, cheers
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top