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.

Ok, here's an update. I have decided to stick with simple loops and if statements for my purposes. I have included the macro in the zip file attached. I'm having trouble with the code snippet below:

Please Login or Register  to view this content.

The problem is that my code inside the if statement never gets executed even though the conditions are true. Does anyone have any clue of what exactly is going on?

Ok, I've managed to debug the code in the last message. I am having trouble with a new task now. Does anyone know how to select a new row of data while having the previously selected cells continue to be selected?

Hi

See if this will get you going.

Please Login or Register  to view this content.

rylo