FULL APPLICATION with VBA in Excel - Check NUMERICAL DATA #10

How to check if the DATA INSERTED in the text boxes are numeric values.
The IsNumric function (TextBox1.Text); the logical operators NOT and OR in the If control structures.
Why is it useful for everyone to learn Excel?
I would say that Excel can facilitate us in almost all work activities, if you use it you appreciate it because it simplifies a lot of operations you do daily; I learned it, then I appreciated it very much and deepened it.
What can you do with Excel?
Excel is a type of program called a spreadsheet. You need it to manage and manipulate numbers and data in general, collected and entered directly or extracted from other organized and structured files or databases.
A spreadsheet like Excel allows you to:
1. enter various types of data
2. collect data from external sources
3. make even very complex calculations
4. process data in various ways
5. generate reports in different forms
6. automate your work
With a spreadsheet you can create and manage documents such as:
1. financial and statistical reports
2. production and logistic reports
3. mono or multi-variable data analysis
4. scientific studies and research
5. catalogs, warehouses, directories
Most of these documents are used to evaluate and control the trend of parameters that measure aspects of reality. For example, the performance of your business, sales, data analysis and so on.
The priceless ability to automate almost all the work, especially the repetitive one, allows you to create real processing, updating and control programs.
How do you use Excel?
It is one thing if you have to do an occasional analysis: extract or insert the data, check it, process it until you get the results, the table and the report, certainly spending the least amount of time compared to what is necessary to do the calculations with the calculator, create tables and draw graphs on a sheet of paper.
Another issue is that of having to periodically update a worksheet, which in my opinion happens most of the time.
With Excel, you can automate almost any repetitive task. Do you need to import data from an external source? Do you need to update the tables, graphs or the entire file? Do you need to check the trend of the values ​​or the presence of errors? Do you need to update the periodic report?
You can do all this using the most advanced Excel tools, programming Macros with the VBA language with which to manipulate any object in the application, creating specific functions and windows of various types, to create a real program.
My VIDEO TUTORIALS are all CLEAR, PRACTICAL and SYNTHETIC, FOLLOW ME and YOU WILL IMMEDIATELY BE OPERATIONAL, with simple VIDEO LESSONS for a few minutes I'll explain what you really need.
If you are interested in LEARNING IT, SUBSCRIBE TO MY CHANNEL, click on the following link:
/ leopoldodellacorte
All Courses and Video Tutorials are organized in special Playlists, CHOOSE the PLAYLIST you want to follow at the link:
www.youtube.co...
#courseexcel
#corsocomputer
#excel
#coding
#vbaexcel
#macroexcel
#vba
#excelbase

[@fender569]

Complimenti

[@alexrinaldi2835]

Comunque ottimi video

[@eduCoding4.0]

Grazie mille Alex

[@robertobraicovick6867]

Grazie!

[@alexrinaldi2835]

Se metti l'If isnotnumeri in un evento change della txtbox direttamente eviti direttamente il messaggio e non ti permette di inserire delle lettere ma solo numeri. Ovviamente cancella il msgbox.

[@cesareminniti3108]

Buon pomeriggio, complimenti per la chiarezza della tua esposizione, ho seguito con attenzione, ma all'undicesimo video mi da un errore nelle righe set lista= LstArticoli.ListItems.Add(text:=cells(rig, 1).value) - non riesco ad uscirne, mi puoi dare un aiuto grazie