I just started working as an intern for a building contractor and was given this assignment. When people are having a house built, they need to choose different options and upgrades. One of the upgrades is for paint. I have very little experience with excel but managed to get most of it to work with functions and links but now I'm stuck. After a couple weeks of digging into the help features and having only suffered two nervous breakdowns, I've almost got it figured out!... but I need help on a couple things.
If a client is choosing different upgrade features and has for instance, chosen the Master Bedroom in Red, both the master bedroom checkbox would be checked and the combo box would be set to red. Now, if the client decides to go with the standard features, they would then click the option button for "Standard Features". Here's the problem: The Checkbox and Combo box for the Master bedroom doesn't reset. Does anybody know a macro, link, function or any other way to make it so that once somebody changes their mind and goes back to standard features, all the upgraded features reset to the unchecked state and the "Choose Color" state?
Any help would be GREATLY appreciated!
Thank you!
Bookmarks