I have a userform where the user can type in info, choose a date in the combobox, and press OK. What i need is a code for the program to automatically find the date in my spreadsheet and put in the information in that row.
What i have now is this: the code finds the next empty row and enters the info.
Private Sub OKButton_Click()
Range("C3").Select
Do
If IsEmpty(ActiveCell) = False Then
ActiveCell.Offset(1,0).Select
End If
Loop Until IsEmpty(ActiveCell) = True
ActiveCell.Value = textbox1.Value
ActiveCell(0,1) = textbox2.Value
ActiveCell(0,2) = textbox3.Value
Unload Me
End Sub
But I really need a way for it to match the date from the combobox to the same date on my spreadsheet and select that cell on the spreadsheet! Will I be able to use an IF statement? If so, can u provide an example? Thank you.
Bookmarks