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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.