filmov
tv
Excel VBA Bangla Tutorial 59 : Multi Pages Data Entry form in Excel and Employee Database | Part- 1
Показать описание
#HasanAcademy #ExcelBanglaTutorial #VbaBanglaTutorial
To create a multi-page data entry form in Excel with VBA, you can use a Userform with multiple pages. Here is an example of how to create a three-page data entry form in Excel:
Open a new Excel workbook and press "Alt + F11" to open the Visual Basic Editor.
In the Project Explorer, right-click on the "VBAProject" and choose "Insert" -"Userform".
Double-click on the new Userform to open the code window.
Add a "Multipage" control to the Userform by going to the "Toolbox" and selecting the "Multipage" control.
Adjust the size and position of the Multipage control to fit the Userform.
Right-click on the Multipage control and choose "Add Page" to create a new page.
Repeat step 6 to create a total of three pages.
On each page, add labels and textboxes for the data you want to collect.
Add a "Next" button to the first page and a "Previous" and "Submit" button to the last page.
Double-click on the "Next" button to open the code window.
Add the following code to the "Next" button to move to the next page:
VBA
Copy code
Private Sub NextButton_Click()
Multipage1.Value = Multipage1.Value + 1
End Sub
Double-click on the "Previous" button to open the code window.
Add the following code to the "Previous" button to move to the previous page:
VBA
Copy code
Private Sub PreviousButton_Click()
Multipage1.Value = Multipage1.Value - 1
End Sub
Double-click on the "Submit" button to open the code window.
Add the following code to the "Submit" button to save the data to a worksheet:
VBA
Copy code
Private Sub SubmitButton_Click()
'Assuming the data in the Userform is stored in textboxes with names like "NameTextbox", "AddressTextbox", etc.
'Assuming the data should be saved in a worksheet named "EmployeeDatabase" in columns A to D, starting in row 2.
With ThisWorkbook.Worksheets("EmployeeDatabase")
.Cells(.Rows.Count, 1).End(xlUp).Offset(1, 0).Value = NameTextbox.Value
.Cells(.Rows.Count, 2).End(xlUp).Offset(1, 0).Value = AddressTextbox.Value
.Cells(.Rows.Count, 3).End(xlUp).Offset(1, 0).Value = PhoneNumberTextbox.Value
.Cells(.Rows.Count, 4).End(xlUp).Offset(1, 0).Value = EmailTextbox.Value
End With
'Clear the Userform
NameTextbox.Value = ""
AddressTextbox.Value = ""
PhoneNumberTextbox.Value = ""
EmailTextbox.Value = ""
'Return to the first page
Multipage1.Value = 0
End Sub
Save the Userform and close the Visual Basic Editor.
Now, when you run the Userform, you will have a three-page data entry form with a "Next" button to move to the next page, a "Previous" button to move to the previous page, and a "Submit" button to save the data to a worksheet named "EmployeeDatabase" in columns A to D, starting in row 2. You can modify the code to fit your specific data entry form and worksheet structure.
Multiple Userform part-1
Multiple Userform part-2
Multiple Userform part-3
Multiple Userform part-4
Most of the people is think about that how I will learn .But they didn't get any idea & trustworthy source. Don't hesitated Hasan Academy with you. You will learn from here, Excel, Excel Chart, Pivot Table, Vlookup, Formula function
To create a multi-page data entry form in Excel with VBA, you can use a Userform with multiple pages. Here is an example of how to create a three-page data entry form in Excel:
Open a new Excel workbook and press "Alt + F11" to open the Visual Basic Editor.
In the Project Explorer, right-click on the "VBAProject" and choose "Insert" -"Userform".
Double-click on the new Userform to open the code window.
Add a "Multipage" control to the Userform by going to the "Toolbox" and selecting the "Multipage" control.
Adjust the size and position of the Multipage control to fit the Userform.
Right-click on the Multipage control and choose "Add Page" to create a new page.
Repeat step 6 to create a total of three pages.
On each page, add labels and textboxes for the data you want to collect.
Add a "Next" button to the first page and a "Previous" and "Submit" button to the last page.
Double-click on the "Next" button to open the code window.
Add the following code to the "Next" button to move to the next page:
VBA
Copy code
Private Sub NextButton_Click()
Multipage1.Value = Multipage1.Value + 1
End Sub
Double-click on the "Previous" button to open the code window.
Add the following code to the "Previous" button to move to the previous page:
VBA
Copy code
Private Sub PreviousButton_Click()
Multipage1.Value = Multipage1.Value - 1
End Sub
Double-click on the "Submit" button to open the code window.
Add the following code to the "Submit" button to save the data to a worksheet:
VBA
Copy code
Private Sub SubmitButton_Click()
'Assuming the data in the Userform is stored in textboxes with names like "NameTextbox", "AddressTextbox", etc.
'Assuming the data should be saved in a worksheet named "EmployeeDatabase" in columns A to D, starting in row 2.
With ThisWorkbook.Worksheets("EmployeeDatabase")
.Cells(.Rows.Count, 1).End(xlUp).Offset(1, 0).Value = NameTextbox.Value
.Cells(.Rows.Count, 2).End(xlUp).Offset(1, 0).Value = AddressTextbox.Value
.Cells(.Rows.Count, 3).End(xlUp).Offset(1, 0).Value = PhoneNumberTextbox.Value
.Cells(.Rows.Count, 4).End(xlUp).Offset(1, 0).Value = EmailTextbox.Value
End With
'Clear the Userform
NameTextbox.Value = ""
AddressTextbox.Value = ""
PhoneNumberTextbox.Value = ""
EmailTextbox.Value = ""
'Return to the first page
Multipage1.Value = 0
End Sub
Save the Userform and close the Visual Basic Editor.
Now, when you run the Userform, you will have a three-page data entry form with a "Next" button to move to the next page, a "Previous" button to move to the previous page, and a "Submit" button to save the data to a worksheet named "EmployeeDatabase" in columns A to D, starting in row 2. You can modify the code to fit your specific data entry form and worksheet structure.
Multiple Userform part-1
Multiple Userform part-2
Multiple Userform part-3
Multiple Userform part-4
Most of the people is think about that how I will learn .But they didn't get any idea & trustworthy source. Don't hesitated Hasan Academy with you. You will learn from here, Excel, Excel Chart, Pivot Table, Vlookup, Formula function
0:27:39
Excel VBA Bangla Tutorial 59 : Multi Pages Data Entry form in Excel and Employee Database | Part- 1
0:03:57
Excel 2010 VBA Tutorial 59 ActiveX Controls Option Button
0:09:13
Excel VBA Bangla Tutorial 04 : Change Tab and Background color in Excel by VBA Macro
0:27:41
Data Entry form in Excel | Average, Sum, minus calculation with Macro | Macro Bangla Tutorial
0:16:22
Excel VBA Bangla Tutorial 15 : Sales Calculator in Excel using Macro Bangla Tutorial
0:09:33
Create Data Entry Form in Excel Without Macro & VBA Bangla
0:14:21
Excel VBA Bangla Tutorial 03 : Change text color & Border Excel VBA Macros Bangla Tutorial
0:15:00
MS Excel Visual Basic (VBA) Bangla Tutorial A to Z (Part 1)
0:13:02
Excel VBA Bangla Tutorial 07 : How to use Formula R1C1 Reference In Excel VBA Macro Bangla Tutorial
0:00:59
Macros in Excel | Excel Macros #macro #excel #exceltricks #exceltips #webtutsaditi
0:04:46
Excel VBA Bangla Tutorial (Part 3) - The Interface of Visual Basic Editor
0:12:20
Excel VBA Bangla Tutorial 43 : Data presentation easily in Excel by graph using List Box
0:10:44
How To Create Microsoft Excel Macro For Web Scraping | Excel Macro Bangla Tutorial | Advanced Excel
0:19:28
Excel VBA Bangla Tutorial 39 : How to Randomly Sort Data in Excel using VBA Macros Bangla | Part 2
0:09:32
Data Entry Form Part 1 Excle Vba bangla, 2019
0:09:33
Excel VBA Bangla Tutorial 21 : Min Value conditional formatting Macro Bangla Tutorial
0:08:14
Excel VBA Bangla Tutorial 01 : Introduction of VBA Macros- How to create First Macro by Bangla
0:07:58
Excel VBA Bangla Tutorial 41 : Delete blank cells in Excel using vba macro Bangla tutorial
0:05:48
Excel VBA Bangla Tutorial 19 : Current Region in Excel using VBA Macros Bangla Tutorial
0:11:09
Excel VBA Bangla Tutorial 36 : Step keyword in excel using VBA macro Bangla Tutorial
0:07:22
Excel VBA Bangla Tutorial 13 : Different way Messages Box create using numerical value in excel
0:11:49
Excel VBA Bangla Tutorial 09 : How to create Messages Box in Excel by Macro- MsgBox Part-1
0:17:24
Excel Data entry form with VBA ( Bengali )
1:03:42
Data Entry form with User form | Data Add | List Box | Data Update| Delete | Option button in Excel
Комментарии