VBA Help

[d0o0n7]

Hi,


Please help me on this I am beginner to VBA .
Learning Forms
so In an Excel VBA form there are few fields like Date, Prefix, Full name....

For Date I Want That Date When We Will Open The Form
For Segment I Have 3 Option 1 - Government School, Private / Public School, Special Category
Prefix Should Be Only - Mr., Mrs., Dr., Ms. & Prof., Father, Sis.
Gender Should Filled Automatically After Filling Prefix
and other fields are simple Entry
After completing the form all data should be pasted into excel sheet in this given format on clicking Enter button. 1 more thing I want is that the name should split in three column 1st name, 2nd name, 3rd name.

other format is given below -

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L
1	Date	Registration Segment	Prefix	Name of teacher	Gender	Date of Birth	Address 1	Address 2	Address 3	City	Pincode	State
Sheet1

I Hope u all understand.

Thanks in advance