Thank you. Where exactly would the target.count >1 go in the code along with the target column <> 14. thanks much.
Max
Thank you. Where exactly would the target.count >1 go in the code along with the target column <> 14. thanks much.
Max
OK how does this look?? It still doesn't seem to work...I made column N a validation...
![]()
Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) Dim sOld As String Dim sNew As String Dim rVal As Range If Target.Column <> 14 Then Exit Sub If Target.Count > 1 Then Exit Sub On Error Resume Next Set rVal = Me.Cells.SpecialCells(xlCellTypeAllValidation) If rVal Is Nothing Then Exit Sub On Error GoTo 0 If Not Intersect(Target, rVal) Is Nothing Then Application.EnableEvents = False sNew = Target.Value Application.Undo sOld = Target.Value If Len(sNew) = 0 Then Target.ClearContents ElseIf Len(sOld) = 0 Then Target.Value = sNew Else Target.Value = sOld & ", " & sNew End If Application.EnableEvents = True End If End Sub
Last edited by maxthebear; 02-18-2009 at 08:05 PM. Reason: Added a line
Does the cell you're changing have validation?
Have you closed and reopened Excel to make sure events are enabled?
If yes to both of the above, post the workbook again, Max.
Entia non sunt multiplicanda sine necessitate
I got out of Excel and back in and it worked. thanks again. I'll post it as solved.........
Max
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks