LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,885
Default Conflicting Code?

Hi
could you post the complete event procedure. In your
posted part for example the application events are not
enabled after entering/changing cell values

-----Original Message-----
I have this code in the Worksheet_change sub to change

the text in the range to uppercase. It works great on its
own. When I add this other section of code, it causes my
uppercase code to work a little bit and then not at all.
I don't understand if the code is conflicting or what.
Any ideas would be great. Thanks. Matt

UPPER CASE CODE:
On Error GoTo Error_handler
If Not Intersect(Range

("c13:c15,E13:e15,g13:g15,i13:i15,k13:k15,m13:m15, o13:o15,H
4:I4,C28:C30,E28:E30,G28:G30,I28:I30,K28:K30,M28:M 30,O28:O3
0"), Target) _
Is Nothing Then
With Target
If Not .HasFormula Then
Application.EnableEvents = False
.Value = UCase(.Value)
End If
End With
End If

OTHER CODE:
If Target.Cells.Count 1 Then Exit Sub
If Intersect(Target, Me.Range("C13:C15")) Is

Nothing Then
Exit Sub
End If
With Target
If .Value = "AL" And Not IsEmpty(Range

("D10")) Then
MsgBox ("Please enter ADDHR = number of

hours worked and reason on the overtime explanation at the
bottom.")
ElseIf .Value = "HDAY" And Not IsEmpty(Range

("D10")) Then
MsgBox ("Please enter HOLWK = number of

hours worked and reason on the overtime explanation at the
bottom.")
End If
End With

.

 
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
Conflicting Calculations Kay Excel Discussion (Misc queries) 1 February 16th 10 10:41 PM
Permutations with conflicting groups tomm tomm Excel Discussion (Misc queries) 1 January 28th 10 02:18 AM
Conflicting vlookups Bruister via OfficeKB.com Excel Worksheet Functions 1 October 17th 09 04:57 PM
Conflicting results in formulas? mikelee101[_2_] Excel Worksheet Functions 4 March 26th 08 02:50 AM
Conflicting VB Code sowetoddid[_37_] Excel Programming 9 June 11th 04 08:19 PM


All times are GMT +1. The time now is 11:14 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"