M
micher
I have a sheet with three columns filled with validation lists, but whe
the user merge cells to input something, for the cells still contai
validation lists, they don’t allow the users input anything excep
choosing from the lists. Therefore, I tried to use SelectionChang
event to delete the validation lists when the users need entr
something in merged cells.
Followed code does delete the validation list in the merged cells
but when the users select an unmerged cell twice the validation lis
also was deleted. How can I improve my code? I use Excel 2002 SP-1.
Thank you a lots in advance.
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
If abortproc Then
aboutproc = True
Exit Sub
End If
Dim cRange As Range
Set cRange = ActiveCell.CurrentRegion
If cRange.MergeCells = True Then cRange.Select
With Selection.Validation.Delete
End With
End Su
the user merge cells to input something, for the cells still contai
validation lists, they don’t allow the users input anything excep
choosing from the lists. Therefore, I tried to use SelectionChang
event to delete the validation lists when the users need entr
something in merged cells.
Followed code does delete the validation list in the merged cells
but when the users select an unmerged cell twice the validation lis
also was deleted. How can I improve my code? I use Excel 2002 SP-1.
Thank you a lots in advance.
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
If abortproc Then
aboutproc = True
Exit Sub
End If
Dim cRange As Range
Set cRange = ActiveCell.CurrentRegion
If cRange.MergeCells = True Then cRange.Select
With Selection.Validation.Delete
End With
End Su