Hi,

is ther any way we can dispay user form and the database similar to access.
my user form dispay one record. while directly under it we display all
records in a table format (or datasheet view as in access)

regards

Hi

Sure, but you'd have to create and program the userform to do it. Which is
pretty fun to do and a great way of learning Excel programming.

But if you just want a form: There is a built-in such thing in menu Data
Form, try that first. Then try John Walkenbach's enhanced dataform, free
downloadable from
http://www.j-walk.com/ss/dataform/index.htm

HTH. Best wishes Harald

"hngo" skrev i melding
...
Hi,

is ther any way we can dispay user form and the database similar to
access.
my user form dispay one record. while directly under it we display all
records in a table format (or datasheet view as in access)

regards