Adding Controls to a Spreadsheet

You can create what Microsoft calls a custom form . A custom form is a worksheet with one or more of the controls that are normally found in a dialog box — for example, option buttons to turn options on or off, or a list box to display a list from which the user can select an item. Thus you can create a user-friendly document that has many of the features usually found only in dialog boxes. 

but not all, of the controls that you have seen in Excel s dialog boxes can be installed on a worksheet. These controls return a value to a worksheet cell (the cell link). You can then use this value in worksheet formulas. 

---

The second set-up concept from Microinnova, the Lab Experiment Toolbox , has some minor differences from the first concept. It was designed to speed up process development and reduce the time to market of chemicals or compounding products (Figure 4.25) [77]. A modular toolbox has been developed for laboratory-scale experiments. Small tube connections are used to connect various unit operation devices to each other. Process control and user interface are based on Fieldpoint and LabView or Microinnova Process Control. The integration of the sensors into the system is different to the previous concept. The Fieldpoint unit has a front panel, where sensors can be added on a plug-and-play basis. All experimental data are stored in spreadsheets, which can be transferred to common spreadsheet... 

---