VBA Encyclopedia
To update on new Automation Techniques using Excel,Ms Access, SQL Server, Power BI and ASP.Net
Showing posts with label
ValidadtionList
.
Show all posts
Showing posts with label
ValidadtionList
.
Show all posts
Wednesday, November 18, 2015
Add ValidationList in VBA
ThisWorkbook.Sheets(1).Range("B6").Validation.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Formula1:="=" & validationrng.Address
Older Posts
Home
Subscribe to:
Posts (Atom)