LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Userform + listbox question

Hi again ,
In an earlier mail i asked about filtering a listbox.
I think i did not explain things clearly enough.
Therefor i'll try again in this post:

I have a little application in Excel with several sheets.
One of the sheets contains client data such as name (columnA), address
(columnB) , etc.....
This range is called DbClients
On a Userform i have a listbox which has the DBClients as rowsource

What i'd like to do is to put a textbox above the listbox to filter the data
in the listbox.
When i type "Carl" in the textbox , the listbox should only show the records
with the name "Carl"

Is there a way to do this or is it to complicated.
I'm using Excel 2000-2002
If not possible, please also reply.
If more info needed , don't hesitate to reply.

Many thanks
MarMo



 
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
Listbox in UserForm Dale Fye Excel Discussion (Misc queries) 0 October 11th 07 09:40 PM
userform listbox cannot get listbox.value to transfer back to main sub [email protected] Excel Programming 1 May 17th 06 09:44 PM
UserForm Listbox in VBC Marcia3641 Excel Discussion (Misc queries) 7 July 22nd 05 10:20 AM
UserForm with ListBox Otto Moehrbach[_6_] Excel Programming 4 December 5th 04 07:30 PM
UserForm ListBox Otto Moehrbach[_6_] Excel Programming 3 December 30th 03 06:22 PM


All times are GMT +1. The time now is 01:15 PM.

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

About Us

"It's about Microsoft Excel"