Log In
Register
Home
February 21, 2018
Offline
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
Offline
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
February 21, 2018
Offline
Hi Philip,
You are legend mate!
Thanks for your prompt action and help.
I am currently testing this and will contact you if required any modifications.
Kind regards,
Azid
October 5, 2010
Offline
no worries 🙂
February 21, 2018
Offline
Hi Philip,
I want to learn VBA (for excel and word). Do you offer such course (including practice sheets)?
How much it will cost ?
Do you also help students if they stuck somewhere.
Thanks in anticipation.
Regards,
Azid
1 Guest(s)
