Please find the attachment.
In attachment I have created userform called "Details_of_Proposer"

First I need a vba code to call the form for data entry

second I need serial number to be automatially generated starting from one while entering the form detals

third I need drop down list in some fields of the form as given below

In Proposal field
Need options like 1) New Policy, 2) Renewal Policy, 3) Expired policy

In Select any one scheme field
Need options like 1) 2 years policy, 2) 5 years policy 3) 10 years polucy

In M/F field
Need options like 1) Male, 2) Female 3) Transgender

In Gender field
Need options like 1) Male, 2) Female 3) Transgender

In Mode of payment field
Need options like 1) Demand Draft, 2) Cheque 3) Online

Also I want all the data to be saved in Data sheet record wise (all Fields one after one)