View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Patrick Molloy Patrick Molloy is offline
external usenet poster
 
Posts: 1,049
Default How do I populate listbox1 using the commandbutton8 (Caption Find)

replace the textbox, ADM_PERSONNEL, and replace it with a combobox which has
A7:A100 set as the RowSource and the same name, ADM_PERSONNEL

also, set the listbox column count to the correct number of columns.




"Joseph Pagan" wrote in message
...
I want to link the find button to the listbox1.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 diferents rows(Proyect) that have the administer personnel.
I hope this helps.
This is the url to download my project
:http://www.4shared.com/file/11064259...e50c/Form.html