I'm have custom data validation in a variety of cells forcing a user to make an entry in prior cells before continuing on to the next cell to ensure each cell has an entry in it. I also need to have validation in some of those same cells to limit what data can be entered into the cell, i.e. YES, NO or Sm, Med, Lg, XL etc. etc. Is there a vba code that would work in conjuction with data validation in a cell to either ensure all the required cells have an entry or limit what can be entered into the cell. Basically in a nut shell I need to ensure a cell has an entry and limit what can be entered into the cell. Data validation appears to let me do one or the other. Any ideas or suggestions is greatly appreciated. Thanks
Ed
Ed