Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 he http://www.excelforum.com/excel-prog...worksheet.html. Please help me finish this project. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 wrote in message ... 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 he http://www.excelforum.com/excel-prog...worksheet.html. Please help me finish this project. |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
i can post in 4shared or you now about one?
"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 wrote in message ... 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 he http://www.excelforum.com/excel-prog...worksheet.html. Please help me finish this project. |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 wrote in message ... 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 he http://www.excelforum.com/excel-prog...worksheet.html. Please help me finish this project. |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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" wrote in message ... 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 wrote in message ... 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 he http://www.excelforum.com/excel-prog...worksheet.html. Please help me finish this project. |
#6
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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" wrote in message ... 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 wrote in message ... 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 he http://www.excelforum.com/excel-prog...worksheet.html. Please help me finish this project. |
#7
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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" wrote in message ... 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 wrote in message ... 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 he http://www.excelforum.com/excel-prog...worksheet.html. Please help me finish this project. |
#8
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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" wrote in message ... 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" wrote in message ... 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 wrote in message ... 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 he http://www.excelforum.com/excel-prog...worksheet.html. Please help me finish this project. |
#9
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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" wrote in message ... 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" wrote in message ... 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 wrote in message ... 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 he http://www.excelforum.com/excel-prog...worksheet.html. Please help me finish this project. |
#10
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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" wrote: 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 he http://www.excelforum.com/excel-prog...worksheet.html. Please help me finish this project. |
#11
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Help Me please this is url to download my
project.http://www.4shared.com/file/11017417...d/forma_3.html "Joseph Pagan" wrote: 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 he http://www.excelforum.com/excel-prog...worksheet.html. Please help me finish this project. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
coding a find button and a listbox to work together | Excel Programming | |||
Help with coding a command button. | Excel Programming | |||
work sheet coding | Excel Discussion (Misc queries) | |||
Command Button coding | Excel Programming | |||
Why does this coding not work? | Excel Programming |