Data Validation & Mandatory Cell

[matty_lou82]

Hi - I have created a drop down list (Column A), and in the adjacent column I need to make it mandatory for completion depending on a specific entry in column A (from the drop down list)

How can this be done? Is this facilitated via VBA code?

 

[6StringJazzer]

It depends on what "completion" means. At what point in the user's process do you need to check to see if there is an entry in column B? Are there entries in other columns that you want to prevent until the user enters something in Column B? I think we need a more complete description of your process.

Normally mandatory fields apply to a form. You check for mandatory fields when the user clicks a Submit button. You can't check before that, because the user could be doing things in any order.

 

[EFANYoutube]

Wrong post

 

[EFANYoutube]

Hi matty
This should fix your issue
Put this in the sheets code
This code will check if the user has changed row(selects a cell in another row) and if so will check that Bcolumn of the previous row is filled. if not then error and it puts the user back to that cell to complete. if it has a value it does nothing

Dim cell As Range
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not cell Is Nothing Then
    If Target.Row <> cell.Row Then
        If ActiveSheet.Cells(cell.Row, 2).Value = "" Then
            MsgBox "Column B must be filled out", vbCritical, "Error"
            ActiveSheet.Cells(cell.Row, 2).Select
        End If
    End If
End If
Set cell = Target
End Sub