User FAQs

If you have a question, please send it to us.

1) Can you describe Data Validation ?
This allows you to create restrictions on the type of data that can be entered in a cell.

2) Are there any shortcut keys that can be used ?
(Alt + D, L) - Displays the Data Validation dialog box.
(Alt + A, V, V) - Displays the Data Validation dialog box.

3) How can I stop the user pasting over data validation ?
Data validation will prevent incorrect values being typed into a cell.
If will not prevent the user from pasting an incorrect value into the cell.
You can prevent this from happening by writing a VBA macro.
This code detects when cells are changed, checks if data validation is present and stops the paste taking place.

microsoft excel docs

Copy the following VBA code and paste it into the corresponding worksheet code module.

Private Sub Worksheet_Change(ByVal Target As Range) 
    If AllCellsHaveValidation(Range("B2:B8")) Then
        Exit Sub
        Call MsgBox("You cannot paste data over cells with Data Validation." & _
                    vbCrLf & vbCrLf & _
                    "Please use the drop-down to enter data.", vbCritical)
    End If
End Sub

Private Function AllCellsHaveValidation(rgeCells) As Boolean
    On Error Resume Next
    rgeCells = rgeCells.Validation.Type
    If Err.Number = 0 Then
       AllCellsHaveValidation = True
       AllCellsHaveValidation = False
    End If
End Function

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext