I try make adding form to add new person information into my regular personal form. I wish just click under name line, then adding form can come out. The adding form allow me to enter first name,last name, address, phone number.. etc. after hint enter buttom, all those inforamtion will be go into regular form by alphabet order. I know this maybe need use excel VBA. is thee any one can write this VBA for make adding form ? Thank you.

select ur whole cells,including title line and name it as a database . Next select tools/"dataform board" and a form in which u can add, select, change data appears automatically with fields accordin to title line. Each field ur enter/or modify/or remove is automatically updated in the right place of ur database . if u want screenshots with mail, ask in this forum.

Dear Taxi: Thank you for help. I was following your instruction -- highlight whole cell including title line, then select Tools, but I can not find any " dataform board and a form in which I can add, select.. ". Would you more detail about how to make a adding form ? Thank you again for your time.

Dear Taxi: Thank you for help. Now I more understand your way. click field name, then choose Date -- Form. Excel display alert dialog box, click ok or enter. Excel will come out blank data form listing all fields name. Thank you for help. One more question : How do I can avoid alert dialog box.

Give a a name to ur whole selection (title and fields)and call it database .Maybe that way u can avoid alert box . U can also have ur own personaliz data form . If u want a sample, i can send u (only on tuesday 8 i'm in week end far from laptop connect)but it's ez to make it with the "help" chapter. C u Next

Dear Taxi: Thank you for help. I would like to get a sample if you can send to me. My e-mail address is -- alpha314@hotmail.com Thank you again.