Step 1 : First create a excel sheet and make column according to your requirement as seen in the screenshot,
be noticed that select the range first where u want to enter the record.
Step 2 : Now press ALT + D + O + O from the keyboard and after that we will get a pop up box just press Ok button
and start your Entry, it look like that
How to Adjust automatic width of Column,according to text
Step 1 : First create a excel sheet and save it with Macro enabled extension,make some entry
Step 2 : Now select worksheet in dropdownlist and write this code
Step 2 : Now select worksheet in dropdownlist and write this code
How to Make a Entry Form in Excel
Step 1 : First create a excel sheet and make column according to your requirement as seen in the screenshot, be noticed that select the range first where u want to enter the record.
Step 2 : Now press ALT + D + O + O from the keyboard and after that we will get a pop up box just press Ok button
and start your Entry, it look like that
