

February 21, 2018

Hi
Can please someone help. I want to write a VBA code for attached sheet.
If client selects Personal in Colum D - no further action required
if selects Business in column D - column E, F, G should be compulsory and requires filling validation to SAVE the file .
Thanks in anticipation,
Regards,
Azid


October 5, 2010

Hi Azid,
Please see the attached workbook which does what you want. I've created data validation lists for Cols D and G.
I've created some conditional formatting formulas which highlight cells in Columns E, F and G if they need to be filled in.
It's a good visual indication to the user what they need to do and you can refer to these coloured cells in the pop-up warning message.
Regards
Phil
1 Guest(s)
