Now we’ve come a long way. Because we created our dynamic table in Excel, and we implemented the required “Mask” or “Form” command in our desktop. Next, click in the cell with the first entry under the first column heading, and then select your newly created item “Mask” or “Form”. The mask then automatically adopts the column headings as input fields and opens immediately.
We could actually leave it that way and simply select the “Mask” item on the tab, and the input mask would open in Excel. But we want to assume that such a list is not only used by the creator, but that it is perhaps on a shared drive, so that the list can also be edited by several users who may not be very familiar with Excel.
So we need a solution to organize the whole thing via a button that is permanently visible and functional in the spreadsheet. To do this, we proceed as follows:
- Click on the “Developer Tools” main tab and select “Button” under “Insert“.
- If the developer tools are not yet activated for you, you will find the solution here with us >>>
- Now your mouse pointer will turn into a kind of drawing tool, and you can simply hold down the left mouse button and draw a button of any size and anywhere (regardless of cell boundaries).
- As soon as you have created the button, a window will open asking for a macro assignment.
If you have already created a macro, you can assign it here. But I assume that this is not the case, which is why you first have to create a macro in Excel. In order to find the macros function, you also need to activate the developer tools again! If you have never done this before, you will also find the solution here with us >>>
In the end it should look like the image below. By the way, the input mask automatically gets the name of the spreadsheet in your workbook. If you want to have a different name there, you can simply give the table a different name. You can find out how this works and how to work with the name manager in Excel here >>>