Data Storage

[atuljadhav]

Dear Sir

Is there any function in excel 2003,
for example details form of employee with heading
name
Address
Date of birth
prev job
profile
ETC

after enter all the details and press "submit" button than the data automatically store in other sheet of file.

 

[VoG]

See if this tutorial on UserForms helps http://www.contextures.com/xlUserForm01.html

 

[atuljadhav]

Its working
but need to learn other function of tool bar like radio button, check box, drop down box, etc

 

[VoG]

Try Googling for Excel Userforms Tutorial. I found this http://www.excel-vba.com/vba-forms-3-1-creating.htm

 

[atuljadhav]

this site not allow to see full details, give me another turorial

 

[VoG]

How about this http://www.excel-vba-easy.com/vba-userform-excel-vba.html

 

[atuljadhav]

its good from prev.but not show how to create list and proper use of chk box

 

[atuljadhav]

if i want to add more field than how can i edit VBA code