Data Validation using VBA in Microsoft Excel.?

Utilizing Microsoft Stand out VBA We’ve obtained a directory of Usernames.This variety is powerful (varies each time I create a savings fund function).The right way to create any data validation cell with this dynamic checklist using ‘microsoft’ Excel VBA.

It seems that you intend to create the data checked cell, using a listing that is actually automatically modified as the number of entries in the list variations.

If you have, the adhering to event handler will accommodate in which goal.This model will verify cell A1 when using the list in column K, K1 for the last gain access to in column NITED KINGDOM.

Transform the A1, “K”, along with $K$1:$K$ references to fit your particular situation.

Confidential Sub Worksheet_Change(ByVal Goal As Range)
Poor LastRow
Practical application.ScreenUpdating = False
curCell = ActiveCell.Address(0, 0)
LastRow = Range(“K” & Rows.Count).End(xlUp).Row
Range(“A1”).Select
Along with Selection.Validation
.Delete
.Bring Type:=xlValidateList, AlertStyle:=xlValidAlertStop, _
Driver:=xlBetween, Formula1:=”=$K$1:$K$” & LastRow
.IgnoreBlank = True
.InCellDropdown = True
.InputTitle = “”
.ErrorTitle = “Invalid Entry”
.InputMessage = “”
.ErrorMessage = “Must choose from the list”
.ShowInput = True
.ShowError = True
Ending With
Range(curCell).Select
End Sub

can you you have to be specific on which you are looking for you may make a macro to accomplish data validation however I do not understand what this data validation cell is

This might be help everyone……
http://www.freevbcode.com/ShowCode.AspID=3115
http://www.a1vbcode.com/snippet-4147.asp.