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)
Bookmarks