The ToolListFull range is used as the ListFillRange for the Combo Box, and ToolList is used for the data validation list. On another worksheet, there are two named ranges – ToolList (A1:A7) and ToolListFull (A1:B7). Then, when you select an item from the drop down list, only the product code is added to the worksheet cell. That way, people will know exactly what they’re selecting, without memorizing a long list of product codes. For example, instead of a single-column list with just the product codes, you could show the product names in another column. In some cases, it’s helpful to have a multi-column combo box. Usually a single column combo box is enough, like this list of weekdays, but sometimes a multi-column Excel combo box is better.įirst, here is a single column combo box, showing a list of weekday names. With Excel VBA programming, you can add a Combo Box to the worksheet, to show a data validation list.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |