Need to Search from Bottom to Top

[iturnrocks]

I have a UserForm that searches through data starting at A1 and going down. A separate UserForm is what pastes the data starting with A1 and going down. Ive found that when my user submits bad data, they just re-submit new data. The problem is that when the code below searches through the data, it finds the bad data first. Is there a way to change this code so it searches starting with A60000 and goes up?

Here is my code

Please Login or Register  to view this content.

[raypayette]

You can build you own find function!

[iturnrocks]

You can build you own find function!

I didnt mean my code as in I wrote it all myself. Most of the code in my sheets are adapted from questions I ask on this forum.

Perhaps a few keywords to get me headed in the right direction.

[raypayette]

I suggest that this is a good time to learn VBA, so perhaps you could buy a book on it such as Microsoft's Excel 2003 Step by Step.

[iturnrocks]

So what I asked about search from bottom to top is possible?

[raypayette]

Yes if you build your own function!

[iturnrocks]

I will figure it out then and share my results

[jasoncw]

Hi, Dan. If you want to just use this in your code, rather than building a function, in your find command, just use:

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

[iturnrocks]

Thank you. Im afraid I may be headed to a Black List for asking too many questions. Perhaps I should spend more time in the New Users Forum helping with the easy questions.

I dont want to upset anyone, and usually I try to ask basic questions but I added the code this time because most people seem to want to know exactly what Im doing and what I have to work with.

If anyone thinks I take take take, and never give, Excel is something I am learning and I am active on about 10 other forums some where I am the expert, and I dont mind sharing what I know there. I understand the frustration if someone gave me a good answer and I asked them to detail how every line works. Of course, some answers I have received came with detailed instructions on what every line does, which is fine with me.