Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-25-2012, 09:42 AM
Bob Gilmore Bob Gilmore is offline Hoe for force text entered into cell to be uppercase Windows 7 32bit Hoe for force text entered into cell to be uppercase Office 2010 32bit
Novice
Hoe for force text entered into cell to be uppercase
 
Join Date: Oct 2012
Posts: 1
Bob Gilmore is on a distinguished road
Default Hoe for force text entered into cell to be uppercase


How do I force data entered into colunms BCD and m to be uppercase. I have seen sub format for one column but not for the four I need.
Reply With Quote
  #2  
Old 10-25-2012, 05:48 PM
grizz grizz is offline Hoe for force text entered into cell to be uppercase Windows XP Hoe for force text entered into cell to be uppercase Office 2003
Novice
 
Join Date: Jan 2012
Posts: 28
grizz is on a distinguished road
Default

this will work but I'm sure some one can shorten it for you
Code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count > 1 Or Target.HasFormula Then Exit Sub
If Not Intersect(Target, Range("A:A")) Is Nothing Then
    Application.EnableEvents = False
    Target.Value = UCase(Target.Value)
    Application.EnableEvents = True
ElseIf Not Intersect(Target, Range("B:B")) Is Nothing Then
    Application.EnableEvents = False
     Target.Value = UCase(Target.Value)
    Application.EnableEvents = True
    ElseIf Not Intersect(Target, Range("C:C")) Is Nothing Then
    Application.EnableEvents = False
     Target.Value = UCase(Target.Value)
    Application.EnableEvents = True
 ElseIf Not Intersect(Target, Range("D:D")) Is Nothing Then
    Application.EnableEvents = False
     Target.Value = UCase(Target.Value)
    Application.EnableEvents = True
 ElseIf Not Intersect(Target, Range("M:M")) Is Nothing Then
    Application.EnableEvents = False
     Target.Value = UCase(Target.Value)
    Application.EnableEvents = True
End If
End Sub
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
'Linking' entered information to other "cells" from an original "cell" in MS Word Wade Word 6 09-03-2012 05:22 PM
Hoe for force text entered into cell to be uppercase Can I force a master slide to have text input limitations? Irene PowerPoint 3 09-21-2011 10:02 AM
VBA Code to auto resize cells when text entered OTPM Excel Programming 0 09-18-2011 04:21 AM
Hoe for force text entered into cell to be uppercase Day and Month to Uppercase Andy2011 Word VBA 1 07-22-2011 04:34 PM
Auto-populate an MS Word table cell with text from a diff cell? dreamrthts Word Tables 0 03-20-2009 01:49 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:21 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft