How would you determine where the new information would go? Do you just want it to go at the end of the list? Where does the file number come from? Where are all of the files that might have information in column C?
The following code puts whatever you type to the bottom of your list:
Private Sub CommandButton1_Click()
'InputBox(prompt[, title] [, default] [, xpos] [, ypos] [, helpfile, context])
strName = InputBox("Write the note you want in Research Comments", "Research Comments")
'Exit sub if Cancel button used or no text entered
If strName = vbNullString Then Exit Sub
Range("E" & Range("E10000").End(xlUp).Row + 1) = strName
MsgBox "Hello " & strName
End Sub
Bookmarks