I have a UserForm which utilizes a section of a worksheet as a
datatable. The form navigates through the records forward and back,
can add new records and edit existing ones. The procedure first
deletes an old range name and creates a new name based on todays total
records.
I have added a listbox wherein I would like to display other records in
the same range which match the content of a text box control on the
same form.
In Access I would use a simple SELECT (fields) FROM (table) WHERE
(field = x). to construct a stmt for the RowSource for the new
listbox. I've tried using Column references for the SELECT as well as
Column Headings and the range name for the FROM. I can't seem to get
anything to work. Any suggestions from anyone??



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/