Worksheets

Back to Homepage

Index

Reference: Data entry using Userform and VBA

^Data Entry

Tax Deadlines

Excel Adding Data Entry Form Option to Quick Access Toolbar

Right-click on any of the existing icons in the Quick Access Toolbar(QAT).
Click on ‘Customize Quick Access Toolbar’.
In the ‘Excel Options’ dialog box that opens, select the ‘All Commands’ option from the drop-down.
Scroll down the list of commands and select ‘Form’.
Click on the ‘Add’ button.
Click OK.

Once you have the Form icon in QAT, you can click any cell in your dataset (in which you want to make the entry) and click on the Form icon.