Userform to Enter NOW() into Correct Cell in Table

[boxface]

I've got a table with Column C being a product number. I want to make a userform for applying a completed time to the product number (in column J).

I've made the userform, but I'm lost when it comes to the code. I've got a text box in which to enter the product number and an Okay button.

If it helps the text box is called txtProductNumber and the Okay button is called cmdAdd.

If I enter say 456789 into the product number field, how do I get this to then enter =NOW() into the date column on the same row? For example, if the product number 456789 appears in this table in cell C56, how do have this userform enter =NOW() in cell J56?

 

[WarfritLive]

How about a formula in J56 that says =IF(C56="", "", NOW())

 

[Rick Rothstein]

You can use this line of code in your CommandButton's Click event...

Columns("C").Find(txtProductNumber.Value, , xlValues, xlWhole).Offset(, 7) = Now

But you will need some kind of error trap in case the user enters an invalid product number.