Results 1 to 4 of 4

Using find function to find entries in multiple cells

Threaded View

  1. #1
    Registered User
    Join Date
    06-21-2007
    Location
    Vancouver, Canada
    Posts
    74

    Using find function to find entries in multiple cells

    Hi,

    I'm aware that find function can be used to find a particular entry/text in a selected area. I'm not sure if find function is only valid for finding texts. Basically, what I'm trying to do is to have the user input the month, day, and time into the text boxes of the dialog box, and have the macro search for a row that has the month, day, and time cells matching the entries, and then highlight the row. The files of the macro is included in the zip file. A sample of the data is included below:

    phase jour period group ID month day hour time standing
    0 1 1 1 65 5 11 10 10:15 1
    0 1 1 1 65 5 11 10 10:16 1
    0 1 1 1 65 5 11 10 10:17 1
    0 1 1 1 65 5 11 10 10:18 1
    0 1 1 1 65 5 11 10 10:19 1
    0 1 1 1 65 5 11 10 10:20 1
    0 1 1 1 65 5 11 10 10:21 1
    0 1 1 1 65 5 11 10 10:22 1
    0 1 1 1 65 5 11 10 10:23 1
    0 1 1 1 65 5 11 10 10:24 1
    0 1 1 1 65 5 11 10 10:25 1
    0 1 1 1 65 5 11 10 10:26 1
    0 1 1 1 65 5 11 10 10:27 1
    0 1 1 1 65 5 11 10 10:28 1
    0 1 1 1 65 5 11 10 10:29 1

    Does anyone know of any good links on find() to get started? I'm pretty confused with the features on the parameters of the function.
    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