A handful of listboxes, arrays for whatever might be dumped into the
listboxes. Move the arrays into and out of the listboxes as the user makes
changes. It's a lot of work, but may be easier than (a) learning to use
Access, or (b) building the Excel-Access infrastructure.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message
...
Hadn't thought about using list boxes - good idea. I actually had a lot
of
code in mind that would have been building up a new form each time and
adding
bunches of text boxes to it. The list boxes would work much better.

"Jon Peltier" wrote:

You can mimic the effect with listboxes and a lot of code.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message
...
Not with the UserForms that Excel has. Excel is very 2-dimension
oriented,
while Access can be thought of as being more 3-dimensional. Excel's
forms
and controls don't provide for doing things like displaying a varying
number
of returned records in a subform (it doesn't even have subforms).
Excel
doesn't have a way to set up relationships between columns on
worksheets
like
Access does between fields in tables.

Sorry to be the bearer of bad tidings. But someone may know of a site
where
something has been worked out either using 3rd party forms or some
slick
VBA
code to pull this rabbit out of the hat, so keep an eye on your
question
for
that kind of answer.

"jackrobyn1" wrote:

is it possible to have 4 subforms embeded in 1 big form in excel like
access
does? in other words i can enter data into 4 worksheets from the same
on
screen form depending on which subform i enter data into.

If it is possible are there any sites i can go to to see examples of
how
its
done?

thanks