As Excel is a great ally when carrying out any work, be it graphics, calculating results and even creating drop-down lists. It also gives us the incredible option to create different alarm messages or reminders for any date that you need to keep in mind.
Many of the users do not know that Excel has this tool and therefore they do not know how to use it. This is very easy to do, for this reason we will give you all the instructions to make alarms or reminders in this program.
How to create a reminder message in Excel?
Reminders or alerts are important , because if you are a person who works a lot in Excel, it may remind you of the delivery of a job. To do this you must create a spreadsheet , then we go to the box that says ‘Programmer’ which is at the top, then we press the first option of ‘Visual Basic’.
Here you will see that a new window opens, at the top we will click on ‘Insert’ where we will press ‘Module’ and you will see that a blank sheet opens. In the sheet we will write the following command ‘Sub’, in this we have to place the name that we want to give the reminder, as follows: Sub Delivery (). When copying that we give enter and you will see that another line appears.
In the middle of these two lines we will copy ‘Msgbox’. Press the space and between quotation marks, write the message you want to get when showing the reminder , “Send finance work.”
At the bottom we will configure the time, for this click on ‘ Thisworkbook ‘ when doing so you will see that the box will be blank again, here we select the section that says ‘General’ and select the option of ‘Workbook’ so that two lines appear In the middle of these lines we will write Application.OnTime TimeValue (“19:00:00”), “Delivery”.
Next we have to save the file, when we do we must select the type ‘Excel workbook enabled for macros’ . We close this file and reopen it, finally when it is time for the reminder, you will notice that a small notice appears indicating the information you entered.
How to create an alarm or alert in Excel?
To make this alarm we have to repeat the first part of the previous process, which is done by entering ‘Visual Basic’, then we press ‘Thisworkbook’. In the first dropdown we will choose ‘Workbook’ and in the second dropdown you can choose ‘Open’.
In the middle of the two lines we will copy: Application.OnTime TimeValue (“10:40:00 am”), “Indicate alarm”. Between the parentheses we can place the time we want the alarm to sound. Right-click on the option ‘VBAProject’, in the menu we press ‘Insert’ and then ‘Module’, you will see that a new window opens.
Now we will write in the new module, in the first line: Sub Indicate Alarm (), then in the middle of the two lines we will copy: MsgBox “Alarm ringing…”. We proceed to save it as ‘Excel workbook for macros’ and close it.
You must enter it again and press ‘Enable content’, we wait for the time for the alarm to sound and that’s it.
Uses that we can apply to create different alarms or reminders in Excel
This software is widely used and recommended for any type of activity. When creating these alarms we can mention that you can make many combinations of these , adapting to the work you need to do at the moment.
You can make alarms to remember dates of the birthdays of friends and friends. On the other hand, you can implement them in your businesses, creating expiration alerts for your different inventories, for this you will only have to make a list with the information of birthdays or your businesses, you can change the color of the cells to identify them.
By doing so, set your appropriate alarm or reminder. Like those examples that we mentioned above, you can make endless of these reminders , for any event that you need to keep in mind.
It is important to clarify that these serve if you are working within an Excel sheet , that is, you can make these alarms while you work in this program to be able to remember. It is recommended that when making these alerts, you have your program updated to its latest version , which will help you more with your activities.
