What is the problem you are having?
To get the string to search for use a simple inputbox. All explained in the
help. No need for a form.
To get the search code record with the macro recorder doing a search at
workbooklevel.
To get the code to add a new worksheet record this in a macro as well.
To get the code to copy the rows record in a macro as well.
Put it all together and you are on your way.
Any particular problems report back.

RBS

"Rumish8086" wrote in message
...
My task is to make a form which does the following: It needs to search an
Excel worksheet for a string of text entered by the user and then spit out
a
new worksheet with only rows containing that data.

Seems like it should be very easy, but I am completely new to Excel and
all
of my attempts thus far have failed. I'm trying to learn some basic VBA as
quick as I can, but some help would be absolutely wonderful.

Basically, the way it should look is this: there should be a box which
asks
for text, let's call this SearchString. And then there should be a button
beneath it that begins the search process (let's call this SearchStart).
After pressing the SearchStart button, the user should see all rows
containing the previously-entered SearchString in a new worksheet.

Easy as that, but I don't know where to begin. Can someone help?

Thanks!