Search results for query: *

I havent got any for findnext, got no idea how to incoporate it into my code. at the moment it just displays first match

Yeh ive looked in the help files, struggling though. Any help would be greatly appreciated

Ive done it now. But if there is more than one match it only displays the first match. Do you know how I can have a next button that will display any further matches. My code now is: Private Sub CommandButton1_Click() Dim fnd As Variant ' this will be the samew as your entry in TextBox1 Dim...

This is all my code Private Sub CommandButton1_Click() Dim fnd As Range ' this will be the samew as your entry in TextBox1 Dim tbl As Range ' this will be the table to search Set tbl = Sheet1.Range("A2").CurrentRegion 'run the search Set fnd = tbl.Find(What:=TextBox1.Value...

same error as previous reply. Its beginning to annoy me now! lol

Another error im afraid. Unable to get the Find property of the Range class. I will send you the file if that makes life easier?

My apologies. Getting the following error: Compile error: Named argument not found It is highlighting the following code - SearchFormat:=False)

Can anyone help. Im trying to search a sheet and display results on a form using labels in excel 2000. Ive nearly done it!!! but am gettin an error. Can anyone please see if they can get it workin. The code is: Private Sub CommandButton1_Click() Dim fnd As Range ' this will be the samew as...

Ive done it now. Thank you very much for your reply.

I want the user to imput into text boxes and click a command button "search", and the matching row/s to be diaplayed in text boxes on a form, like records.

Ive used Access to search a table and display results on a form but can this be done in excel? For example, I want the end user to be able to enter "first name" into a text box, and "Surname" into another. I want the rows in excel to be searched and if they match the input to display that row in...

I have populated a combo box which does so after initialising. How can I open a form based on the selection the user makes in the combo box? Example: Select "June2008" in combo box and form called June2008 opens.