Checking values in two cells and proceeding if they match

[justme101]

Hello all,

The subject might sound pretty simple to some experts but I am just a beginner at coding and wanted some help here. Let me try to explain the issue as clearly as possible.

1. There is a sheet with some cells which are to be filled up by the user and then a button (called the "SAVE" button) is given which saves the filled-up data to a different sheet in the same workbook and resets the fields.
2. There is a cell (F5) where a drop-down gives the user an option to select a value out of 4 options.
3. If the user selects the value "Others" in F5, he needs to give some details in cell G5 and it CANNOT be left blank and the user gets a popup saying "You need to enter a description if you have selected "Others"".
4. If the user selects any other option in F5, he can leave cell G5 blank.
5. Only if these conditions are fulfilled, the save and reset codes will run, otherwise not.

I wrote some code after searching a lot on Google but could not find something which works for me. Can you guys help me out, please? Thank you.

 

[mikerickson]

Something like

With Workbooks("Book1.xlsm").Worksheets("Sheet1")
    
    If .Range("F5").Value = "Others" and .Range("G5").Value = vbNullstring Then
        MsgBox "G5 needs to be filled"
        Exit Sub
    End If

End With
' the rest of your code

 

[justme101]

Something like

With Workbooks("Book1.xlsm").Worksheets("Sheet1")
  
    If .Range("F5").Value = "Others" and .Range("G5").Value = vbNullstring Then
        MsgBox "G5 needs to be filled"
        Exit Sub
    End If

End With
' the rest of your code

Thanks so much for this. But I think I failed to elaborate point no.4, where if the user has selected any value except "Others" the cell G5 NEEDS to be BLANK, your code skips that check, I just tried it.

I actually wrote some code after I posted the issue here and it partially worked, because I was missing the "Exit Sub" line (silly me) and your code gave me that idea. If you can amend your answer, I'll use that, as it looks cleaner and might help others too or I can go with mine.

 

[justme101]

Also, I have another scenario related to the same issue, with a slight difference. Should I ask about that here or create a new thread?

 

[mikerickson]

Thanks so much for this. But I think I failed to elaborate point no.4, where if the user has selected any value except "Others" the cell G5 NEEDS to be BLANK, your code skips that check, I just tried it.

I actually wrote some code after I posted the issue here and it partially worked, because I was missing the "Exit Sub" line (silly me) and your code gave me that idea. If you can amend your answer, I'll use that, as it looks cleaner and might help others too or I can go with mine.

No it doesn't check that scenario, it sounds like an If .... ElseIf ....End If construction would work for that.