VBA or Macro code required

[adityaj252]

Hi Everyone,

I have a business requirement where there are total of 3 columns A, B and C. Column A is a dropdown field with let user choose one value from dropdown values (total of 5). Now, if user selects any specific value out of these 5, he/she should get a message popup that column B becomes mandatory corresponding to that A value. In case, if user selects some other value in A column, C column should become mandatory. So I want B and C column to become mandatory only for a specific value of column A but not for all.

Your prompt response would be greatly appreciated.

 

[smozgur]

Welcome to the MrExcel Message Board!

Note: You initially posted your question to the wrong section (Products forum) and it has been moved here by a Forum Moderator. Please send your future Excel-related questions to this forum - the Excel Questions forum.

Regarding your question. It is possible to check the value of the cell on column A when it is changed and popup a message accordingly, however, I hope you understand it is only for informing the user, not actually forcing them to enter something to column B or C.

Please go to VBE (Alt+F11), double-click on the worksheet class module (Sheet1?) in the VBA Project (Ctrl+R) window, and copy & paste the following code into that class module:

Private Sub Worksheet_Change(ByVal Target As Range)
    ' Column = 1 means it is Column A
    If Target.Column = 1 Then
        ' Used 1,2,3,4,5 as the list for the dropdown values
        Select Case Target.Value
            Case 1, 3, 4
                MsgBox "Column B is mandatory"
            Case 2, 5
                MsgBox "Column C is mandatory"
        End Select
    End If
End Sub

The sample code contains 1,2,3,4,5 values in the dropdown list and sets the specific values as shown in the Select Case to decide which column to be mandatory. You need to change those by using your values and criteria.