Hi all
I have a worksheet that has a number of cells that is used to effectively act as a way of checking eligibility for a service.
These cells are, say;
A2, C2, E2
A8, C8, E8
A14, C14, E14
At present, the user has to manually check that two or more of the above cells has a value/text in it, before pressing an existing command button that opens another sheet for more info to be input.
I'm trying to find a way of adding some code to the existing button that checks each of these cells to see if more than one of them has a value/text in. Should less than two contain a value/text, I want a msgbox to appear (I'm ok with that bit lol) informing the user they are not eligible. They will then not be allowed to access the other sheet.
After doing some reading, I thought a SELECT CASE statement might help but have no idea what I'm doing, what code I should add, or whether there is a better way.
Any ideas gratefully received. Thanks
I have a worksheet that has a number of cells that is used to effectively act as a way of checking eligibility for a service.
These cells are, say;
A2, C2, E2
A8, C8, E8
A14, C14, E14
At present, the user has to manually check that two or more of the above cells has a value/text in it, before pressing an existing command button that opens another sheet for more info to be input.
I'm trying to find a way of adding some code to the existing button that checks each of these cells to see if more than one of them has a value/text in. Should less than two contain a value/text, I want a msgbox to appear (I'm ok with that bit lol) informing the user they are not eligible. They will then not be allowed to access the other sheet.
After doing some reading, I thought a SELECT CASE statement might help but have no idea what I'm doing, what code I should add, or whether there is a better way.
Any ideas gratefully received. Thanks