MS Excel UserForm With Database Macros Project-23 Video

MS Excel UserForm With Database Macros Project-23 Video

In This Project Video, we are going to learn how to create a Microsoft Excel UserForm with database macros, which can be Created Easily by following the steps in the video.

Preview MS Excel UserForm With Database Macros Project

Read Also: MS Excel Course Details, Fees, Duration, Scope, Syllabus, Admission, Institutes & Jobs

UserForm Coding

Dim fpath As String
Private Sub CommandButton1_Click()
Dim x As Integer
Application.FileDialog(msoFileDialogOpen).AllowMultiSelect = False
x = Application.FileDialog(msoFileDialogOpen).Show
If x <> 0 Then
fpath = Application.FileDialog(msoFileDialogOpen).SelectedItems(1)
Image1.Picture = LoadPicture(fpath)
Image1.PictureSizeMode = 1
End If
End Sub

Private Sub CommandButton2_Click()
Dim x As Long
Dim y As Worksheet
Set y = Sheet2
x = y.Range("A" & Rows.Count).End(xlUp).Row
With y
.Cells(x + 1, "A").Value = TextBox1.Text
.Cells(x + 1, "B").Value = TextBox2.Text
.Cells(x + 1, "C").Value = TextBox3.Text
.Cells(x + 1, "D").Value = TextBox4.Text
.Cells(x + 1, "E").Value = TextBox5.Text
.Cells(x + 1, "F").Value = TextBox6.Text
.Cells(x + 1, "G").Value = ComboBox1.Text
.Cells(x + 1, "H").Value = ComboBox2.Text
.Cells(x + 1, "I").Value = TextBox7.Text
.Cells(x + 1, "J").Value = TextBox8.Text
.Cells(x + 1, "K").Value = TextBox9.Text
.Cells(x + 1, "L").Value = TextBox10.Text
.Cells(x + 1, "M").Value = TextBox11.Text
End With
On Error Resume Next
Dim i As String
i = TextBox1.Text
FileCopy fpath, "C:\vedantsri\" & i & ".jpg"
Me.TextBox1.Text = ""
End Sub

Private Sub UserForm_Initialize()
TextBox1 = Application.WorksheetFunction.Max(Sheet2.Range("a2:a1000")) + 1
End Sub

Show Form Button Coding

Sub RectangleRoundedCorners1_Click()
UserForm1.Show
End Sub

About VedantSri

VedantSri Computer Institute provides the best Computer Courses, Classes, and Training in Varanasi. There are NEILIT Courses, CCC, BCC, O-level, Certificates, and Diploma Computer Courses available with the best training materials. Also Available: Top 100 Best Computer Courses, For Example, OM, DCA, ADCA, DTP, DFA, ADAM, ADTP, ADFA, DCE, MS Office. VedantSri Computer Coaching update CCC Online Test 2023 in www.vedantsri.net. (MS Excel UserForm With Database Macros Project)

There are some important computer Courses for jobs, CCC Class, Typing, Internship, and Spoken English Available Free of cost with an offer. More than 50 Computer Courses are available with a 50% fee discount at VedantSri Varanasi. You can get the Best Digital Marketing Course at Varanasi Institute VedantSri. There is a Latest Computer Course Offer in ADCA Computer Course, DCA Computer Course, CCC Computer Course & English Spoken.

About the CCC Online Test

MS-Word Online Test:- This is the CCC Online Test Website Page. If you are preparing for the CCC Exam or any other competitive exam, you should visit the website at www.vedantsri.net. You can also download this app from the Play Store, and you will find many more online test series related to MS Word, MS Excel, MS PowerPoint, and Internet-related topics. MS Excel UserForm With Database Macros Project-23 Video

VedantSri Computer Institute in Varanasi provides this. The VedantSri provides the best computer classes, Courses, coaching, and Computer Training in Varanasi, Uttar Pradesh, India.

Important Links

• 1-VedantSri Official Website:- https://vedantsri.com
• 2-VedantSri Student Website:- https://www.vedantsri.net
• 3-Students Jobs Assist Website:- https://www.jobdo.in