Excel is a program developed by the Microsoft company. Mainly designed to make it easier for us to perform calculations. It is an excellent way to carry out and organize our finances and accounting tasks.
If we have a business or need to carry out tasks that require complex calculations in Excel, it will be very useful. It is a very complete program capable of carrying out difficult activities such as adding cells from different sheets, extracting and obtaining initials of a name, multiplying in an Excel sheet automatically, among many others, we just have to learn to use it and make the most of everything that we can. offers.
One of these tools is Tabstrip, knowing how it works will be of great help when working with Excel. In this article we will focus on teaching you how to use the TabStrip command specifically to make a capture form.
How to make a capture form using Tabstrip control?
The Tabstrip control is a tool within Excel whose main function is to allow multiple pages to be created on the same form. Which is the same as saying that it serves as a page separator but related to the same area.
From the visual point of view, it can be seen how within the same form there are several pages, which are related to the same topic. All this is done by means of commands, which will be indicated below by means of an example, to make the subject more understandable.
Steps to make capture form using Tabstrip control
The first thing we need to do is open Excel. In this case we will make a form for a business in charge of selling delicatessen and greengrocery. We will open two tabs and create a table for delicatessen and another for greengrocery.
These tables will have three columns, one for the code, another for the name of the product and the last one for the price per kilo, in each row we will insert the values ​​for the product. Next, we click on design mode to start entering the commands.
We must start with an index 0, then we will start writing the codes in the save button where we will insert the values ​​for each product. This is very useful, since it will allow us to have control of the instructions by grouping them.
To start writing the commands we must start by writing select case. Next, an expression to evaluate, which can usually be a numeric variable. What we actually do with this step is evaluate the expression to perform a specific block of code.
Once we have written case and the list of instructions, to write another block code we write case again and follow the instructions. Depending on the value that the expression to evaluate takes, a group of Instructions will be made and not the other.
Once the above has been done, we will have a case else statement that allows us in the event that the variable has not taken any of those values ​​that we have previously defined. Whatever we have in the case else is done, finally, we end the statement with end select.
In this case we will have two blocks, one to fill in the data within the delicatessen tab and another for greengrocery. For this example we are using three integer time variables which are code, product and price per kilo.
Finally, it is important to save each item that we make with the End If command, after completing all the commands for the two tabs, we will click on save in the upper left corner.
Then we select in Design Mode to exit the design mode, and we can start adding the data in the spreadsheet for each product. The name of the product and the price per kilo and we click on save.
When selecting in the charcuterie tab all the data that we enter will be automatically saved in the charcuterie table one by one. And when selecting the greengrocery, the entered data will be saved in the greengrocery table, so we must continue doing it until we finish with all the products.
Knowing how to work with commands like Tabstrip is very important, because they will save us time and help us to do the job much better and without errors. Like this, there are many command tools provided by Excel.
