Need to populate data in listbox based on textbox value change

Hi All

I need help to making a userform, my userform contains (1 textbox , 2 labels , 1 listbox , 2 buttons(clear & cancel))

I tried my best but i unable to make it perfect..

I need help to populate data in listbox based on textbox change, below is my condition

required column Headers in listbox is "Acno Nbr","investname","amount"

- textbox contains only number if user enter text then msgbox should show plz enter numbers only & as well as in lable
- our account nbr which we are enter in textbox that should be start from "9" if user enter number otherthan "9" , msg should show invalid number & as well as in lable
- if user entering the number & whatever the number user enter listbox should populate required data whatever the account nbr starting with that number(textbox value)
- suppose if user enter only lessthan 10 & greaterthan 10 then in lable show invalid number u have enter lenght of account nbr(textbox value)
- suppose if textbox value is available in worksheet then in listbox populate the required data and in lable populate "yes it's power goal number"
- suppose if textbox value is not available in worksheet then in lable show "no records found - might be its not a power goal number"

i hope my explanation in clear & understandable & if not plz let me know

plz see attached file..

For starters,

try this code ,

Please Login or Register  to view this content.

Hi xlbiznes

thanks for quick reply,

but its meet 60% requirement, suppose if i enter "910" in textbox then listbox should show all the account nbr which is starting with 910 just like google search

Here you go,

Please Login or Register  to view this content.

Hi xlbiznes

xllent its working charms !! thanks...

tommrow i will give u feedback after fully varified...

Code added to your original file.

Thanks for extremely nice support xlbiznes, its working xlent but i need small clarification.

- suppose when i am entering otherthan 9 msgbox giving popup but when i pressing backspace again msgbox giving popup but that should not give.
- when i am entering some numbers in textbox and listbox populating the values but again when i am pressing removing value in textbox then listbox not getting clear...

Try this updated one with user input checking.

Hi xlbiznes

Wow !! now its perfect, a very big thank you so much , really u itself a programer

Done ! my query got resolved now...

Wish You Happy New Year

You are welcome, glad i could help. Wishing you the same.