Debug Errror - In User Form

When I open the form, then I get the following debug error. Previously, it would populate the "Document Affected" but it was in the wrong column.
This is the debug error that I get:

ActiveCell.Offset(0, 3) = txtDate.Value

I do have the date...is there something wrong with the way that line is written?

Please Login or Register  to view this content.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Thank you! As I said before, the code previously worked, and they asked to have a box added for the date and now I can't get it to work.

as Artik said there is no control called txtDate in that form

nor are there txtFromRev, txtToRev or txtSpecificsOfChange controls

Originally Posted by JosephP

as Artik said there is no control called txtDate in that form

nor are there txtFromRev, txtToRev or txtSpecificsOfChange controls

Forgive my ignorance, but do you mean on the form itself? Because the form does have all of those.

no it doesn't- there are no controls with those names on there

I know I'm driving you crazy, but I see it on the form and I see it in the code

Please Login or Register  to view this content.

I'm obviously missing something, but I don't know what. =(

it's in the code but none of the textboxes on your form have those names which is why you get the error. they appear to be called textbox4, textbox6, textbox7 and textbox8

Wow! The lightbulb finally went on when you said textboxes!! Thank you for your patience and for solving my issue!!