![]() ![]() To show the item name, instead of the item number, you can use an INDEX function in another cell. In the screen shot above, February was selected, and a 2 is entered in cell D5. That item’s index number (its position in the list) is entered in the linked cell. The font size can’t be changed though, so the list would be hard to read on a zoomed worksheet.Īlso, you can’t type in the box, so click the arrow, then select an item from the list. The drop down arrow is always visible, so the Form Control combo box is easy for users to find on the worksheet. You can also link the combo box to a cell, so the selected item number appears on the worksheet. You can adjust the number of drop down lines in the Form Control Combo box, so you can show all 12 months, without a scroll bar. It gives you a bit more control over the appearance of the drop down list. Instead of using data validation, you could use a Form Control Combo Box. You can’t change those settings, but you can colour the data entry cells, to make them obvious to the worksheet users. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |