Skip to main content

Do you know we can create a User-Form Without VBA? 

Let Me Explain!
First Goto Quick Acess Toolbar -> Use More Commands->select All commands as shown in the Picture below:

Then Find Form Command by Scrolling down and Add to the Quick Access Toolbar

Then Add the Column Headers and Row Headers as per below Picture and Press Form Button in Quick Access Toolbar

and Then Add data within the form and Data Entry is Simple. Hope you enjoyed. Further questions, feel free to msg me @ 9611344773 or write an email to vijay.perepa@ameetz.com
Best Regards
A meet Z Tech Team

Comments

Popular posts from this blog

Calculating CAGR with PowerBI

Calculating CAGR using POWER BI. Watch,Like,Share and SUBSCRIBE https://youtu.be/tB5yEnzmOSQ

Visual Tool Tip - Jun 2019 Update

Jun 2019 Update - Visual Tool Tip - Using Customised Tool Tip you can create Visual Tooltip to Show Additional information for Each Visualisation. Watch and Subscribe

Interactive Excel Chart with INDIRECT Function