Chapter 25. Spin Buttons, Scroll Bars, Option Buttons, Check Boxes, Combo Boxes, and Group List Boxes
I need to run a sensitivity analysis that has many key inputs, such as sales, annual sales growth, price, and unit cost. Is there a way I can quickly vary these inputs and see the effect of the variation on the calculation of net present value, for example?
How do I set up a simple check box that toggles conditional formatting on and off?
How can I set up my worksheet so that my supply chain personnel can click a button to choose whether we charge a high, low, or medium price for a product?
How can I create an easy way for a user of my worksheet to enter a day of the week without having to type any text?
User forms enable the Microsoft Office Excel ...
Get Microsoft® Office Excel® 2007: Data Analysis and Business Modeling, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
