value of Column and Row, How can I get the cell where the column and row intersect?

[Carvel647]

Hi,

I have a table where Box #'s are in Rows and Dates are in Column. 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. Can someone please help me? Thank you so much

Please Login or Register  to view this content.

Screenshot.png

[TMS]

You can use Cells:

Please Login or Register  to view this content.

Regards, TMS

[Carvel647]

Thanks for the speedy reply. I'm still relatively new to VBA coding and I tried working with my code with your suggestion and it doesn't work. Can someone offer more insight or walk me through my code to help me understand my errors.

Please Login or Register  to view this content.

[TMS]

I suggest you post a sample workbook with some typical data.

The way you have coded it looks OK, at least at first glance.