Hello There,
I would like to do the following:
There are certain mandatory cells marked with * and need to be filled. There is a button. On click it should check if the cells with * signs have a value corresponding to its data type.
example First name (characters only), Date of birth (date), Age (Numbers only).
If any mandatory cells are left empty then it's border should be red colour and a message is displayed on a certain column ("Some mandatory cells need to be filled") in red. If all mandatory cells are filled it should activate worksheet "Sheet2".
I have attached a sample workbook for your reference.
Could you please help to achieve this via VBA?
Looking forward to hearing from you
Thanks & regards
Don
I would like to do the following:
There are certain mandatory cells marked with * and need to be filled. There is a button. On click it should check if the cells with * signs have a value corresponding to its data type.
example First name (characters only), Date of birth (date), Age (Numbers only).
If any mandatory cells are left empty then it's border should be red colour and a message is displayed on a certain column ("Some mandatory cells need to be filled") in red. If all mandatory cells are filled it should activate worksheet "Sheet2".
I have attached a sample workbook for your reference.
Could you please help to achieve this via VBA?
Looking forward to hearing from you
Thanks & regards
Don