Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jennifer
 
Posts: n/a
Default validation rule - force text entries to appear as Proper

Is there a way to force text entries using Data validation such that any
entries will appear in the Proper format?

test = Test
Test= Test

Thanks!
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kletcho
 
Posts: n/a
Default validation rule - force text entries to appear as Proper

A couple of ideas. You can either use data validation to warn them
that the first word is not proper or you can always force it to be
proper using VBA.

With VBA:

Put this in the worksheet module of the sheet you are affecting:

Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo ErrorHandler
Target.Value = Application.WorksheetFunction.Proper(Target.Value)
ErrorHandler:
End Sub

Or with data validation use custom and then put this formula in:

=and(Code(A1)=65, Code(A1)<=90)

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel save as csv - force text qualifier on every text field Newbie-Don Excel Discussion (Misc queries) 6 April 2nd 23 08:33 PM
Validation rule nick Excel Discussion (Misc queries) 4 March 6th 06 05:57 PM
Force values-only when pasting text to keep formatting BethP Excel Discussion (Misc queries) 2 November 17th 05 08:57 PM
How to force a wrap text function when the cell is big enough to p Jason Bathon Excel Discussion (Misc queries) 1 April 13th 05 03:21 PM
How can I force certain text formatting in a cell? eddied Excel Discussion (Misc queries) 2 February 7th 05 01:55 PM


All times are GMT +1. The time now is 11:46 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"