User Input value to the cell where the column and row intersects

[jtn260]

Hi,

I have a table where Box #'s are in Row 2 and listed in each column and Dates are in each row in column A. I use the find function to find two cells based on the user input of box # and date. Now that I have these two cell, I want to find where the row and column intersects and allow the user to enter a number there using an input box. Below is what I have so far. I think I need to somehow index the cells, but am not sure how. I've attached my Excel file below if someone could take a look at it and help me? Thank you so much I am relatively new to VBA and would appreciate if someone can point out my error and guide me through the process. Thanks

Please Login or Register  to view this content.

FindDateBoxMacro.xlsmFindDateBoxMacro.xlsm

[mikerickson]

Try

Please Login or Register  to view this content.

[jtn260]

Thank you mikerickson. It doesn't seem to work. I receive a Compile Error: Expected Function or variable when I try to run it. When I take the ".Activate" out of my Find lines I don't receive the compile error, but the code still doesn't perform what I need it to do. Any other ideas of what could be wrong. Here is my code:

Please Login or Register  to view this content.

[protonLeah]

Please Login or Register  to view this content.

[jtn260]

Thank you so much ProtonLeah. Works Great! I have another question. I need this to run continuously because the user will be making multiple entries into the worksheet. Is there a way that I can continue to run this macro repeatedly until the user clicks "End" in some type of message box? Thanks again!

[protonLeah]

Please Login or Register  to view this content.