PC Review


Reply
Thread Tools Rate Thread

coding a find button and a listbox to work together

 
 
Joseph Pagan
Guest
Posts: n/a
 
      5th Jun 2009
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.
 
Reply With Quote
 
 
 
 
Joseph Pagan
Guest
Posts: n/a
 
      5th Jun 2009
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 (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.

>
>

 
Reply With Quote
 
Joseph Pagan
Guest
Posts: n/a
 
      5th Jun 2009
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.

>
>

 
Reply With Quote
 
Rick Rothstein
Guest
Posts: n/a
 
      5th Jun 2009
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.

>>
>>


 
Reply With Quote
 
Joseph Pagan
Guest
Posts: n/a
 
      5th Jun 2009
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.
> >>
> >>

>
>

 
Reply With Quote
 
Rick Rothstein
Guest
Posts: n/a
 
      5th Jun 2009
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
news32B6E5F-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.
>> >>
>> >>

>>
>>


 
Reply With Quote
 
Joseph Pagan
Guest
Posts: n/a
 
      5th Jun 2009
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 here:
> http://www.excelforum.com/excel-prog...worksheet.html. Please help me finish this project.

 
Reply With Quote
 
Joseph Pagan
Guest
Posts: n/a
 
      8th Jun 2009
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 here:
> http://www.excelforum.com/excel-prog...worksheet.html. Please help me finish this project.

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: coding a find button and a listbox to work together Rick Rothstein Microsoft Excel Programming 0 5th Jun 2009 08:17 PM
Using the find button does not work and gives this comment Robin Scott Microsoft Word Document Management 0 16th Nov 2008 07:54 PM
Listbox coding problem george 16-17 Microsoft Access Form Coding 8 28th Feb 2008 09:21 PM
Listbox VBA Coding Asif Microsoft Access 7 5th Apr 2007 03:32 PM
Find Command Button - It used to work =?Utf-8?B?RG9uIElyZWxhbmQ=?= Microsoft Access Form Coding 6 9th Feb 2006 02:12 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:35 AM.