VBA Script to allow formulas and drop down boxes?

[orangebloss]

Hi

from reviewing the forums I think VBA might be able to help solve my problem but I'm not sure how... Any thoughts gratefully received!

I have a list of sections that will be selected as installed or not installed and all part numbers within that section need to first be switched to match the section status

e.g. Section = Installed

PN1 Installed
PN2 Installed
PN3 Installed

That's the easy bit using the formula if(Section="Installed","Installed,"No")

However some of the parts will need their status tweaking (i.e. if that particular part in not required on this installation)
e.g. Section = Installed

PN1 Installed
PN2 Not required
PN3 Installed

this works fine if I use the formula and then select from the list box... but if I change my mind and want to for e.g. change the entire section to Not Installed then any part numbers I have altered using the drop down don't change.

I figure there must be a way to do it but I'm not sure how?