Hi Karen

then you'll need to create a userform in the VBE window and code it. Have
you done any work with VBA before?

Cheers
JulieD


"Karen" wrote in message
...
I want a stand alone form. The user won't see the spreadsheet where the
information is kept. Something like the example below:

Search for:

Where it: [Drop down: Begins In OR Contained In]
the Employee's [Drop Down: First Name OR Last Name]


"JulieD" wrote:

Hi Karen

two inbuilt options that you might like to have a look at as long as your
data is in "database / list" format
ie something like
..........A..............B.....................C.. ....................D
1.....First Name...Last Name.....Address.........Town.
2.....Joe..............Bloggs............15 North Rd.....Little Parks

click in cell A2 choose data / filter / autofilter - you'll see a drop
down
arrow for each column, click on the one for last name and choose the
person
you're interested in

or two
click in cell A2 and choose Data / form - click on the Criteria button,
type the last name in the last name field and click Find Next

if neither of these two are acceptable, could you explain a bit more on
what
you mean by "form" - do you want one like the data / form one, or do you
just want a cell where they can type the name in or a combo box where
they
can select it from

Cheers
JulieD

"Karen" wrote in message
...
I have a simple address book spreadsheet. I would like to create a
Search
form, where the user can enter the Last Name of the person they are
searching
for.