Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default coding a find button and a listbox to work together

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,934
Default coding a find button and a listbox to work together

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default coding a find button and a listbox to work together

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default coding a find button and a listbox to work together

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,934
Default coding a find button and a listbox to work together

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,934
Default coding a find button and a listbox to work together

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default coding a find button and a listbox to work together

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,934
Default coding a find button and a listbox to work together

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,934
Default coding a find button and a listbox to work together

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default coding a find button and a listbox to work together

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default coding a find button and a listbox to work together

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
coding a find button and a listbox to work together Rick Rothstein Excel Programming 0 June 5th 09 08:17 PM
Help with coding a command button. dan dungan Excel Programming 2 April 27th 09 07:53 PM
work sheet coding Dad Excel Discussion (Misc queries) 3 December 23rd 07 11:08 PM
Command Button coding Corey Excel Programming 1 November 23rd 06 09:44 AM
Why does this coding not work? rammieib Excel Programming 7 February 21st 06 11:57 AM


All times are GMT +1. The time now is 09:58 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"