VBA Encyclopedia
To update on new Automation Techniques using Excel,Ms Access, SQL Server, Power BI and ASP.Net
Wednesday, November 18, 2015
Add ValidationList in VBA
ThisWorkbook.Sheets(1).Range("B6").Validation.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Formula1:="=" & validationrng.Address
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment