Forum Discussion

Uguey's avatar
Uguey
Copper Contributor
Mar 17, 2020
Solved

Excel mandatory cell with dropdown menu

Hello everyone   I have basic information in let's say columns M, N and O. In column P I have a dropdown menu consisting of 3 different names. What I would like now ist 1) that if any data in co...
excel
  • Savia's avatar
    Savia
    Mar 17, 2020

    You can do this with a very small macro on the page itself:

     

    Private Sub worksheet_Change(ByVal target As Range)

    If Not Intersect(target, Range("M:O")) Is Nothing Then
    MsgBox ("You must now change the dropdown in column P")
    Else
    End If

    End Sub

     

    I have attached an example - press Alt F11 to open the VBA editor and see the code in situ.

Savia's avatar
Savia
Iron Contributor
Mar 17, 2020

You can do this with a very small macro on the page itself:

 

Private Sub worksheet_Change(ByVal target As Range)

If Not Intersect(target, Range("M:O")) Is Nothing Then
MsgBox ("You must now change the dropdown in column P")
Else
End If

End Sub

 

I have attached an example - press Alt F11 to open the VBA editor and see the code in situ.

Meredith_S's avatar
Meredith_S
Copper Contributor
Jan 13, 2021

Savia I'm new to VBA, how can i just make the dropdown mandatory? this is a table where data entry is ongoing

Resources