Okay, I got your sample worksheet, but I'm not entirely sure how to answer
your original question. You asked for a TextBox where you can type in a name
and have a ListBox populated with "all the data to the respective fields". I
see names repeated in several row for both Column A and Column C... how did
you want the multiple names handled (and for which column)? When you say
"all the data", exactly what did you want displayed in the ListBox... every
column? I think you will need to provide a lot more detail as to what you
want and how you want it laid out AND what did you want to happen when a
user clicks an entry in the ListBox.
--
Rick (MVP - Excel)
"Joseph Pagan" <(E-Mail Removed)> wrote in message
news

32B6E5F-BA2E-48DE-8D35-(E-Mail Removed)...
> Okay this is the link thanks
> http://www.4shared.com/file/11010197...9/forma_3.html
>
>
> "Rick Rothstein" wrote:
>
>> I don't know of any specific ones (I don't use them myself), but I know
>> other posters have posted worksheets using them.. so I know they exist.
>> You
>> will have to do a Google search to find one (unless some here who knows
>> of a
>> specific one posts the information here).
>>
>> --
>> Rick (MVP - Excel)
>>
>>
>> "Joseph Pagan" <(E-Mail Removed)> wrote in message
>> news:1D9D7139-C7AD-4FBA-B12E-(E-Mail Removed)...
>> > what site can you recommend please?
>> >
>> > "Rick Rothstein" wrote:
>> >
>> >> It seems you need to register and login to download your posted
>> >> workbook
>> >> from that site. I (and I am sure many others here) tend to limit the
>> >> number
>> >> of sites we register with, so I (we) can't see what you posted. Can
>> >> you
>> >> post
>> >> it to one of the many free websites (that do not require registration)
>> >> designed to do take user postings?
>> >>
>> >> --
>> >> Rick (MVP - Excel)
>> >>
>> >>
>> >> "Joseph Pagan" <Joseph (E-Mail Removed)> wrote in
>> >> message
>> >> news:E07F29FB-AAD9-46BA-9566-(E-Mail Removed)...
>> >> >I am using excel 2003 vba.I want to complete a project only left
>> >> >create
>> >> >a
>> >> > find button and a listbox, so when i type a name in the textbox1 the
>> >> > listbox
>> >> > is populated with all the data to the respetive field so i can chose
>> >> > what
>> >> > record of that person to updated. I post my project here:
>> >> > http://www.excelforum.com/excel-prog...worksheet.html.
>> >> > Please help me finish this project.
>> >>
>> >>
>>
>>