Display an error message based on particular condition

**aman1234** · 12-29-2009, 03:33 AM

Hi guys

When the whole row in excelsheet is full for particular date that means all the values of columns (Legal Charge,GA and DNM) have been entered for particular date then display an error message if the another user tries to enter the values for the same date .
It means the user can enter the values for same date only if values of Legal Charge,GA and DNM are empty,otherwise an error message should pop up.

Please Login or Register  to view this content.

Can anyone please figure out my problem.

Thanks
Aman

**Leith Ross** · 12-29-2009, 04:38 PM

Hello aman,

The values "Legal Charge and DNM" are selections in ComboBox2. Is the value "GA" also a selection in ComboBox2? If the values are selection in ComboBox2 then how does work?

It means the user can enter the values for same date only if values of Legal Charge,GA and DNM are empty,otherwise an error message should pop up.

**aman1234** · 12-30-2009, 04:55 AM

Yes, all the values (Legal Charge,GA,DNM) are in combobox2. I want to display an error message if the user has already input the values of Legal Charge,DNM and GA in the excelsheet for particular date and tries to input them again for the same date.

Thanks
Aman