Hello lnh2204,
Welcome to the Forum!
The macro below will find the name and then the date. The cell containing the date will be changed to "w". In VBA using Ranges and the Find method offer you a wide range of options in searching.
Sub Macro1()
Dim Cell As Range
Dim Rng As Range
Dim sDate As Date
Set Rng = Range("A1:A100")
' Convert string date into a Date type.
sDate = CDate(TextDate.Value)
' Find the name in column A.
Set Cell = Rng.Find(cboCandidateNames.Value, , xlValues, xlWhole, xlByRows, xlNext, False, False, False)
' Look for the date if the name was found.
If Not Cell Is Nothing Then
' Look in the name row columns D to M.
Set Rng = Cell.Offset(0, 4).Resize(1, 10)
Set Cell = Rng.Find(sDate)
' Change the date to "w".
If Not Cell Is Nothing Then Cell.Value = "w"
End If
End Sub
Bookmarks