coding a find button and a listbox to work together

[Joseph Pagan]

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-programming/685778-coding-a-textbox-to-search-in-the-worksheet.html. Please help me finish this project.

 

[Joseph Pagan]

i can post in 4shared or you now about one?

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?

 

[Joseph Pagan]

what site can you recommend please?

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 Rothstein]

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).

 

[Joseph Pagan]

Okay this is the link thanks
http://www.4shared.com/file/110101972/d24acc69/forma_3.html

 

[Rick Rothstein]

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.

 

[Joseph Pagan]

I want to link the find button to the listbox.Example: The user enter the
name of the ADM_PERSONNEL in the textbox named ADM_PERSONNEL in the userform
and click the find button automatically the listbox is populated with the
data in that row for the field
ADM_PERSONNE,ADM_TITLE,PI_PD_NAME,UNIT,AGENCY,FILE_NO ect...So i can chose
and look the diferent row(Proyect) that have the administer personnel.
I hope this helps.

 

[Joseph Pagan]

Help Me please this is url to download my
project.http://www.4shared.com/file/110174178/b97258ed/forma_3.html