Populate Data In Listbox Based On Textbox Value Change

I need to make 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 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"

See attached file..