Hi all
Been a long time since I've used VBA and a little rusty, so thought I'd seek some help.
I've got a spreadsheet that contains two tabs:
1: Eligibility
2: More info
Within the Eligibility tab there are four fields called Criteria 1, Criteria 2, Criteria 3 and Criteria 4 that the user enters either a Yes or No into.
I need to insert a button that will check each of these fields and if a No is present in all four, a message box needs to appear explaining they are not eligible.
If a Yes is present in 1 or more (meaning they are eligible) it needs to open the More Info tab for additional data to be input.
I'm ok with the message box and open tab code, but I'm struggling to find a way round the first bit.
Any pointers or help much appreciated!
Thanks
Been a long time since I've used VBA and a little rusty, so thought I'd seek some help.
I've got a spreadsheet that contains two tabs:
1: Eligibility
2: More info
Within the Eligibility tab there are four fields called Criteria 1, Criteria 2, Criteria 3 and Criteria 4 that the user enters either a Yes or No into.
I need to insert a button that will check each of these fields and if a No is present in all four, a message box needs to appear explaining they are not eligible.
If a Yes is present in 1 or more (meaning they are eligible) it needs to open the More Info tab for additional data to be input.
I'm ok with the message box and open tab code, but I'm struggling to find a way round the first bit.
Any pointers or help much appreciated!
Thanks