You could try :data :template wizard if it helps to solve
your problem
-----Original Message-----
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/

.