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