![]() ![]() This is important, because those words will be used as Excel names, and two-word names are not allowed as names. NOTE: The Produce list has one-word items in it - Fruit and Vegetable. Excel For Mac 2011 Making A Named List For A Drop Down List In Excel.How to create a drop down list box on a User Form Using Excel 2011, is it possible to create a drop down list box on a user form? I don't want a combo box because that combines a text and list box and allows the user to enter their own data - I want them to pick from the list items. Most items populate across the 7 columns when I select the drop down but after line 22 only the first column shows in the drop down but the other 6 columns don’t populate. I have a list with 7 columns on a separate sheet from the worksheet with the drop down.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |