I have a list of numbers in column B. I created an ActiveX Combobox consisting of one of all the part numbers listed in column B. When I click on a part number in the Combobox, I would like to have today’s date appear on the same row as the part number in Column G. For example if I select number 3504 in the Combobox which happens to be in B14 and B28, then today’s date is automatically entered into G14 and G28. The code I currently have does not do anything when I click on a value in the ComboBox. I have included the code below. I am VERY new to VBA so I am not really sure what I’m doing.
Private Sub ComboBox1_Change()
Dim CellValue As Long
Dim Worksheets As Worksheet
Dim cell As Range
For Each cell In Range("B10:B81")
If CellValue = ComboBox1.Value Then
Sheet11.Cells(cell, ColumnG).Value = Now()
CellValue = CellValue + 1
End If
Next cell
End Sub
Bookmarks