Smart Data Entry form with minimum VBA
In this article, we have a Smart data entry form for candidate information with minimum VBA. We have used Excel formulas, conditional formatting and Form Controls. You can replicate this
Tag: Data Entry form in VBA
VBA Application with MS Access Database
In this article, we have create a VBA application with MS Access database using ADODB connectivity. We have created the Rent Management System. We have used VBA user form with
Excel VBA based Application with SQL database
In this article, we have created a Excel VBA based Application with SQL database. We have used ADODB connection to connect the database. In this application we have created Insert,
Data Entry Application in Excel VBA
In this article, we have created a Data Entry Application with List box in Excel VBA. Data is saved in the same Excel file on Database worksheet. You can Add,
Login Form for Excel VBA based Application
Login Form is very important for any application. We have designed this Login form in VBA User form and connected with MS Access Database. We have used ADODB Connection to
VBA: Multilevel dependent drop-down in User Form
While creating the data entry form in VBA, we need to put several validations. One of them is dependent drop-down. In this article you will learn how to create multilevel
VBA: User form Validation for Mobile Number input
While create the Data Entry form in VBA, We need to put some validation in text boxes and combo boxes. In this article you will how we can put the
Quick Data Entry Form (Without VBA)
If you don’t know the VBA and want to create a Quick Data Entry then don’t worry in this article you will learn how to create/open a data entry form
Data Entry Form in Excel
This data entry form has been designed in VBA. You can enter the EMP ID, EMP Name, Gender, Designation and Salary. Since Excel sheet is protected so data can not