Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Need character for custom format to force upper case!

I am trying to mask the input into cells to force as uppercase only.
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Need character for custom format to force upper case!

Try this sub taken from a post by Tom Ogilvy
which will force uppercase in col A:

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
On Error goto ErrHandler
If Target.Column = 1 Then
Application.EnableEvents = false
Target.Value = UCase(Target.Value)
End if
ErrHandler:
Application.EnableEvents = True
End Sub

To implement: Right click on the tab of the sheet
where you want this behavior and select view code,
then paste in the above procedure

Adapt the target col to suit:
col A = 1, col B = 2, ...

Success? Click YES button below.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:370 Subscribers:68
xdemechanik
---
"Andrew C" wrote:
I am trying to mask the input into cells to force as uppercase only.

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,520
Default Need character for custom format to force upper case!

Private Sub Worksheet_Change(ByVal Target As Range)
Target.Value = UCase(Target.Value)
End Sub

If this post helps click Yes
---------------
Jacob Skaria


"Andrew C" wrote:

I am trying to mask the input into cells to force as uppercase only.

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
Format cell to convert to Upper case widman Excel Discussion (Misc queries) 4 June 3rd 08 08:29 PM
Changing file in all upper case to upper and lower case Sagit Excel Discussion (Misc queries) 15 May 30th 07 06:08 AM
how do I format a cell to display its contents in Upper case? MarcM Excel Discussion (Misc queries) 1 March 8th 07 03:19 AM
Force upper case? Trevor Coultart Excel Discussion (Misc queries) 5 July 6th 05 01:22 PM
Upper Case and date format issue Andy Tallent Excel Discussion (Misc queries) 3 April 8th 05 04:52 AM


All times are GMT +1. The time now is 02:15 AM.

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

About Us

"It's about Microsoft Excel"