I’m working on to build a simple data entry form for my users where I need to validate one scenario Please see the same data. Field Name DataType Dropdown values Name Text NA DOB Date NA Offer Related List Items 1. Welcome Offer 2. Shopping Offer 3. Weekend Offer 4. Other Card Number Number NA Statement List Items 1. Email 2. Physical Copy 3. SMS If user selects Datatype = List Items then the user cannot leave the “dropdown values” cell with null value, I want to validate and prompt user using MsgBox alert. I want to achieve this validation using VBA code as I have other validation for the same cell range using data validation. Can someone help?

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Do not allow blank or null if Adjacent Cell Contains Specific Text in Excel using VBA code

Thread starter anbaz
Start date Dec 17, 2022
Tags

rick rothstein's corner siddharth rout

anbaz

New Member

Dec 17, 2022

I’m working on to build a simple data entry form for my users where I need to validate one scenario

Please see the same data.

Field Name	DataType	Dropdown values
Name	Text	NA
DOB	Date	NA
Offer Related	List Items	1. Welcome Offer 2. Shopping Offer 3. Weekend Offer 4. Other
Card Number	Number	NA
Statement	List Items	1. Email 2. Physical Copy 3. SMS

If user selects Datatype = List Items then the user cannot leave the “dropdown values” cell with null value, I want to validate and prompt user using MsgBox alert. I want to achieve this validation using VBA code as I have other validation for the same cell range using data validation.

Can someone help?