Checking values in two cells and proceeding if they match

justme101

New Member
Joined
Nov 18, 2017
Messages
34
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.
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

mikerickson

MrExcel MVP
Joined
Jan 15, 2007
Messages
23,985
Something like

VBA Code:
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
 
Solution

justme101

New Member
Joined
Nov 18, 2017
Messages
34
Something like

VBA Code:
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

New Member
Joined
Nov 18, 2017
Messages
34
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

MrExcel MVP
Joined
Jan 15, 2007
Messages
23,985
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,130,130
Messages
5,640,300
Members
417,135
Latest member
zeusmining

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top