Dynamically update Listbox in userform with Table(address,phone no, name ) in excel sheet

Hi friends

i am using USERFORM (Excel worksheet is hidden) <----------this is completed

On userform i have a textbox_1 and commandbutton (abc_cmd) and ListBox1

when i type in "textbox_1" and click "abc_cmd" it is written/pasted in excel<----------this is completed

NOW ? begins

when i click "abc_cmd" whatever goes in excelworksheet should also be seen in ListBox1 (update listbox dynamically) ?


please help me with the code
thanks in advance

i gave the "ROWSOURCE = Table1 ....in VBA property widow...it does get added but until we close the form and reopen it doesnot showup in ListBox.
i want it to reflect as soon as i click abc_cmd

You might try Userfom1.Repaint