locate cell using match index (date & time)

**rakesh.a.r** · 07-03-2012, 10:24 AM

Hi,

I need a solution for a challenging problem. I have time mentioned in the rows & date mentioned in column. I need to select and highlight a cell which intersects between particular time & date based on inputbox.

Ex : I have two input box (a). for Time, (b). for date
I will enter time when first input box pops & I will enter date when second input box pops up. based on these two values, the vba has to locate a cell using index match & highlight the respective cell.

I am a beginner & I have been trying to solve this from 2 weeks despite no solution.

Any help or suggesstions will be highly appreciated.

Thanks in advance

**Richard Buttrey** · 07-03-2012, 11:00 AM

Hi,

One way would be

Please Login or Register  to view this content.

I've not allowed for any validation checking or for someone entering a date or time that isn't present in the table.

**MarvinP** · 07-03-2012, 11:03 AM

Hi rakesh,

Find attached another way to do it. I've keyed on two cells in sheet 1 instead of input cells. See if you can add your inputbox to this code to do what you want.