Results 1 to 4 of 4

locate cell using match index (date & time)

Threaded View

  1. #1
    Registered User
    Join Date
    06-27-2012
    Location
    Bangalore
    MS-Off Ver
    Excel 2007
    Posts
    5

    Smile locate cell using match index (date & time)

    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
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1