Mandatory and interdependant fields

Hi all,

this is my first thread so be gentle to me . I am not so new to VBA, but i am a little bit stuck. I have two questions.

I have a form (Excel, of course) which needs to be filled following some criteria. I have a filed name "Clause of non-compete" and you have to choose between YES and NO. This field has to be mandatory. I did that with the following code (see below). Now i have another field that says: If YES, should it be maintained? How can i make the second field to be dependant on the first one and mandatory? I want it to be mandatory only when there is Yes in the first field (merged field N35:O35).

Can you please help me on this?


Thanks,

Dan

Please Login or Register  to view this content.

Moderator Note:

Pls take a look to forum rules. No 3 of these requires to use code tags around your codes. THIS time i added for you.

Hi, 2Real,

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Ciao,
Holger

Hi, Dan,

code for ThisWorkbook:

Please Login or Register  to view this content.

Code behind sheet "Formulaire DEPART" adapted to match row 2:

Please Login or Register  to view this content.

Ciao,
Holger