VBA Script to allow formulas and drop down boxes?

orangebloss

New Member
Joined
Jun 5, 2013
Messages
34
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?
 

Some videos you may like

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

Watch MrExcel Video

Forum statistics

Threads
1,099,787
Messages
5,470,778
Members
406,720
Latest member
tylergaps

This Week's Hot Topics

Top