Developer tab excel 2007 add4/1/2024 ![]() ![]() You could for example, set up combo boxes so that people can select how often each day do a particular task and then take those responses and manipulate this data directly from the combo boxes. You have more flexibility of response compared with check boxes and by linking the output of the combo box to another cell, the selected answer from the combo boxes drop down list can be stored as a number for further manipulation.Combo boxes give you the option of a configurable list in a drop down menu as a posed to a check box which is binary (on / off, yes / no etc). ![]() Combo boxes have a number of advantages over check boxes and other methods of gathering input from other users of your Excel spreadsheets. These are very useful for recording situations where a yes / no answer or condition is required. In part one I looked at how to set up checkboxes ( ). Welcome to part two of my series on Excel. ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |