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

Combining Many Files into one Table with Power Query in Power BI

Transform many CSV files, in a Folder, into a Table in Power Query Editor with single Click. And the same process you can follow in Excel as well. for more updates keep watching, Like, Share and SUBSCRIBE

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