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;
http://www.youtube.com/watch?v=XBi_cU...

If this has helped you then please like and subscribe.
Thanks for watching