TextBox gets contents from dynamic user pick?
 

Hi Experts!
I was wondering how I could get a textbox or even a list box to be populated
with contents from a Excel Workbook as and when a user picks cells.
All I need is a form with a textbox to load when the macro is launched.If
the user clicks a cell at random(and assuming the cell has contents), its
contents are transferred to the textbox on the form.
If you can add some advice for getting the same on a listbox.That is much
appreciated as well.
Thank you
Gowri