creating "Find" button on userform for editing data

[madhg]

I've created a userform following the tutorial http://msdn.microsoft.com/en-us/library/aa192538.aspx

And a Find button which reads a string from a textbox, searches for it on the worksheet, and then displays the data for that row in the userform.

I'm trying to work out how to do "Find Next", and it seems complicated. I know there are other techniques, such as filtering, or displaying all the found data in a dialog for user to choose which one to edit. But these are not suitable for my project.

Here's the code for my Find button

Please Login or Register  to view this content.

So, is there a good way of doing "Find Next"? I use Excel 2000.

[royUK]

Taake a look at the databaseform here

http://www.excel-it.com/vba_examples.htm

[madhg]

Take a look at the databaseform here

http://www.excel-it.com/vba_examples.htm

Thanks for your reply. I have looked at the data form on that website, which I knew about because you regularly point users to it. The data form uses a filter, which in my case I don't want, as I mentioned in my post.

[royUK]

I can't see why a filter is not suitable, maybe if you attach your workbook

[madhg]

I thought about this and eventually worked out how to do it.

I'm searching one column. A public variable StartSearch holds the row number of the cell where .Find found the given text. Then the next search starts from that cell. So pressing the Find button repeatedly cycles through all occurrences of the given text. That works fine for me.

The user enters the string to search for in a textbox tbxFindText and then presses button Find.

Please Login or Register  to view this content.

[royUK]

AutoFilter would be faster