search and move active cell to matched data

hi,

I'm back again. I was able to get some help here before and Im hoping for another answer to my question. I need help with the code I have below. Actually the code was also taken from some of the threads I was able to read here. I need help in moving the active cell to the matched search data found. Currently the code below does not move the active cell to the matched searched data. Say, if a user will type employee id, once the user click the find button, it will return a value from the label I have but will not move the active cell to the matched or searched data. Please help me move the active cell to the matched searched entry. Thanks

Please Login or Register  to view this content.

Cheers,

Stoey

Hi

Try changing

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

rylo

hi,

wow that works. thanks! now how do I go about highlighting the entire row of the searched data?


Cheers,

Stoey

Hi

define "Highlight". Do you want it bolded, or have a pattern??? What formatting do you want to apply?

To select the entire row, then try

Please Login or Register  to view this content.

Having selected it, you can then apply some sort of format. Or you can use the same approach without actually selecting it

Please Login or Register  to view this content.

HTH

rylo

hi rylo,

thanks again for your reply and assistance. I tried the code you have given and indeed no doubt it worked. But the problem is, the color stays to the row it highlighted. How can it be possible to just simply highlight the row and not make the highlight color stay. My worksheet have colors. I would like to use yellow color for highlighting but I dont want the highlighted color to stay on the selected row. I appreciate your kindness. Thanks

Cheers,

Stoey

Stoey

I just put up the color as an example. If you only want a temporary highlight, the only thing I can think of is to select the entire row.

It will show until you move the cursor.

rylo

hi rylo,

thanks for your reply again. Yes you are right. That's what I did. I just used the .entirerow tag instead. Thanks a lot you were able to help me a lot.

Cheers,

Stoey