Excel Macro - How to add a dropdown menu to a cell aka Data Validation
A simple macro tutorial showing how to create a macro that will add a drop down menu to a cell of your choice with the variables you define.
Code :
Sheets("Sheet1").Range("B4").Select
With Selection.Validation
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:=xlBetween, _
Formula1:="=Sheet2!$A$1:$A$5"
.IgnoreBlank = True
.InCellDropdown = True
End With
For some of the previous tutorials we have covered please visit the link below.
Insert row video;