Drop-downs, VBA and most of Contextures is passé. Just describe your given task in English and maybe share your database in a linked file. You might have to learn a lot of new stuff. Please sign in to rate this
Using Form ListBox does not make much senseas just as well we haveData Validationallowing you to set a drop down list to any Excel cell. See my post onExcel Cascading Drop-downsif you want to see how powerful this can be. Beware in below examples I am using the ActiveX ListBox instead!
depending to the data in the Table 1 , create dynamic drop down list to be ability filling the Table 2 according to administrative division to three level , each admin level depends on the previous admin level (please see the file attached) note: I use Excel 2016. thanks! ThanksTheAntonys...
Contingent drop downs was my first thought but I don't think this will work with the way the data is set up. Thanks! GrahamB2360 To achieve the functionality you described, you maybe can use a combination of Excel formulas such as INDEX and MATCH,...
2. In the popped outMatch Import Picturedialog box, please do the following operations: Specify the picture order from the Import order drop down list, you can chooseFill vertically cell after cellorFill Horizontally cell after cell; Then, from theMatch rangetextbox, select the picture names th...
How to select multiple items from Excel Data Validation drop down list, all in one cell. Short videos, written steps, free Excel workbook to download
Any help on multiple choice drop downs in adobe? I can do it with a VBA Code in Excel, but i am unfamiliar with Adobe. Using Adobe Acro Pro 2020, TIA. Votes Upvote Translate Translate Report Report Reply Correct answer by try67 Community Expert , Mar 17...
Any help on multiple choice drop downs in adobe? I can do it with a VBA Code in Excel, but i am unfamiliar with Adobe. Using Adobe Acro Pro 2020, TIA. Votes Upvote Translate Translate Report Report Reply Correct answer by try67 Community Expert , Mar 17, 2025 Copy...
Worksheet Lists for Cell Drop DownsOn another worksheet in that Excel file, there are two named lists:DayList - list of weekdays, in cells A1:A7 MonthList - list of months, in cells C1:C12Those lists are used to set up the data validation drop down lists on the data entry sheet....
In Excel 2007, and earlier versions, you can use Excel VBA code if you want to automatically filter multiple pivot tables at the same time. That task is much