Learn Excel VBA and Develop your own Software Free , एक्सेल व्ही बी ए सीखो , और बनाओ अपना सॉफ्टवेअर घर बैठे

We see, everywhere there are various software's, which are standalone or dynamic, every software has its quality and attributes, 

To develop any kind of software, we need complete knowledge of application, that we use to develop it, there are various programming languages and tools through which, we can develop any kind of software, website application,

there is a big scope for development in information technology, 

to develop any kind of application, software, website, we need to know the programming language, 

well, for that there are various courses available to be, IT engineer, to be a developer

Today will see how to develop a normal VB application that is a visual basic application with the help of EXCEL VBA

What can we do with excel VBA ?
Why use Excel VBA?
How to learn Excel VBA?
What are the possibilities with Excel VBA ?
Template of user registration Form with Excel VBA ? 

VBA is nothing but visual basic for applications, VBA looks like VB 6.0 our VB.net, though it's using code of VB it's not VB 6.0, VB.net

VBA is a part of Excel, it's just functionality that is added by Microsoft in office Excel, we can make simple applications through VBA, the best part is every software need database for the backend but here in VBA Excel itself is a database

What is Excel VBA? एक्सेल व्ही बी ए क्या है ?

Though Excel VBA is not IT development software like Visual Studio,Visual basic 6.0,  it has many capabilities like a visual basic studio,

Visual Basic Excel is used in Excel so that there is no need of a database, Excel itself is a database for visual basic application

With the help of VBA, we can develop small applications that can useful for Excel users, 

with Excel VBA, we can develop student registration application with visual basic forms, we can develop billing system of any small shop, we can develop information tracking system, like these various things that we can do with Excel VBA  and we can officially launch it also, for small scale businesses

Why use Excel VBA? क्यो  है जरुरी एक्सेल व्ही बी ए ?

As we know, for learning any kind of development course we need a lot of time and money also,

Microsoft office is familiar with every individual since his or her childhood, office

Is a famous platform, that we use to keep track of information,

Most of the individuals are familiar with Microsoft Office Excel, that's why those who need to learn any software development language, Excel VBA is the best platform to learn

The reason why to choose Excel VBA is just cause of individual comfort with Excel

How to learn Excel VBA? कैसे सीखे एक्सेल व्ही बी ए ?

Though I say, an individual can develop software with VBA, Excel VBA having some limitations, Excel VBA is just a part of Excel to use it smartly

So the users who know the Excel, but don't know Excel VBA, initially you need to to learn some basic things of visual basic, we can develop various applications with the help of Visual basic

The person who learns the basics of visual basic can make a simple application in VBA

The good part is, visual basics having design controls are ready to use like, for designing registration form, we have various controls like text box, label, command button, listview available readymade with tools, we just need to design a form, we can see how our design looks like, by run it

The important part is what actions we are going to take with this design?? Like when,

To design user form for user registration, after adding all details, we need to submit those details to the database, for submit it, we use command button with caption submit when user click on submit button, data entered in user form expected to save an excel sheet as per our requirement

For this we need to write code, click action of submit button, that is the most important part of visual basic, I will see this code with design snaps to understand better.....

Student Registration form

So for developing any kind of software with VBA, the design part is very simple, but coding must need to learn to develop the application of how to learn

What can user do with Excel VBA? एक्सेल व्ही बी ए के साथ युजर क्या क्या कर सकता है ?

Though excel VBA is not a full-fledged programming language,

We can develop simple applications by using VB, we don't need any external database to configure with it, cause Excel itself is a database

For creating big data, with effective search and edit capability, we can use Excel VBA,

As I say, with the help of Excel VBA, we can make Windows-based applications like billing system, student registration system, tracking system, likewise various applications we can develop with the help of Excel VBA

Though these applications need very few efforts to develop, the important thing is there is a lot of scope for earning purpose also,

There are various grocery shops, medicals, milking parkers, small schools, need to to use simple software that they can use ti keep precise track of their valuable information

The office is easily available anywhere today, and users also familiar, with Microsoft Office Excel and to develop any kind of application software, we don't need lots of efforts that we need in actual visual basic software, cause as we see Excel itself is a database so the developer just needs to focus on coding to learn the cause, design, and database is already with him or her...

User registration form with Excel VBA ,युजर रजिस्ट्रेशन फॉर्म विथ एक्सेल व्ही बी ए 

Now we see, a simple user registration form with submit button, to save information in Excel

For this open Excel,

Press alt + 11, to view the visual basic environment in Excel, you can see the toolbox, various menus, properties window, modules, etc

For inserting a form, go to file-- insert user form, you will get a new form design with you on the screen,

Now place various labels and text boxes to excel VBA form, for design purpose,

At last insert command button also for action code to write, to save data in excel sheet

By inserting various controls, we need to give names also to these controls with the help of properties window

Now I will enter code that we need to use for the action of saving data from users form to Excel sheet...

Private Sub CommandButton1_Click()       // Click event

Dim x As Long                        

Dim y As Worksheet

Set y = Sheet1

x = y.Range("A" & Rows.Count).End(xlUp).Row + 1

With y

.Cells(x, 1) = txtid.Text

.Cells(x, 2) = txtname.Text

.Cells(x, 3) = txtphone.Text

.Cells(x, 4) = txtaddress.Text

End With

MsgBox "Record added"

End Sub

....

dbl click save button you will get code window

RUN BUTTON TO EXECUTE PROJECT

....

Just double click on the command button you have taken, you will get to click event of that particular command button just use above code there... And simply run this form you will get user registration form as output

AFTER RUN STUDENT  FORM

It's a simple development, there are various things more than this in excel VBA,

We just need to learn a code of action...

Saved Record

Thank you