macro to create a drop down list | MrExcel Message Board
Jun 8, 2011 · Hello, Regarding the creation of a list (Insert or delete a drop-down list - Excel), is it possible to do this as a macro? Thank you!
Unable to remove drop down box | MrExcel Message Board
May 29, 2015 · Hi I have an Excel (2016, O365) sheet with a blank drop down box that I just can't delete. I have tried all the suggestions listed on this forum and others but the drop down box still remains. …
Drag And Drop File VBA | MrExcel Message Board
Jan 15, 2005 · Delete the old file that was originally dropped. I intend to have hundreds or potentially even thousands of files in the references folder, and use as-you-type searching in Access (which I've …
Deselecting an item in a multiselect dropdown list - MrExcel
May 12, 2021 · Hello, I created a multi-select drop down list in my Excel sheet, but now I am unable to deselect my options. If I make a mistake and choose the wrong option, I am unable to remove that …
vba code to hide a drop down box | MrExcel Message Board
Dec 16, 2009 · hi, Can somebody help me figure out what the correct vba is to hide a drop down box? I am running a macro that hides particular cells, but I can't seem to hide the drop downs.
Data Validation List-Doesn't Ignore Blank Cells - MrExcel
Apr 19, 2010 · I am creating a data validation list, and I see the option to ignore blank cells and I check that box, but then when I create my list box there is still blank selection options that show up. For …
VBA to deselect a single value in a multi-selection drop down list ...
Apr 26, 2024 · I have a VBA script that allows me to select multiple values from a drop-down list in the cell but will not allow me to deselect a single value. For Example, I have selected 5 names from a …
VBA - auto-clear dependent dropdown when target changes (data ...
Jun 15, 2017 · [TD] [/TD] [/TR] </tbody> [/TABLE] Each cell is a dependent dropdown list (except row A, which is just a normal list). The choice B1 depends on the choice in A1 (INDIRECT function), C1 …
Reset Button to clear cell value and not cell formatting
Jul 30, 2014 · On a form I developed, these cells are formatted with a border, color and a drop-down list. I created a RESET BUTTON to clear these cells, but when you press the reset button it also clears …
VBA: Dependent Drop Down List (Clear cell) - MrExcel
Apr 20, 2011 · Alm5423 A J Default Value in cell adjacent to drop down list johannes2008 Nov 9, 2025 Excel Questions Replies 2 Views 31 Nov 10, 2025