This is the best video to start learning Advance Userform in Excel with Hindi Language
Aao kuch advance sikhte hai jo abhi tak youtube me nahi tha
Dosto Daood Computer Centre me aapka Suwagat Hai
Is video mein aap sikhenge ki kaise excel advance userform banaye or kaise userform ki suruat kare is video me hamne bilkul step by step aapko bataya hai is series ke aage ke video jald hi upload kar diye jayenge
aapse mera nivedan hai ki aap video ko like kare share kare or agar channel ko pahli baar dekh rahe hai to subscribe kare or sabse mahatvpurn ke aap ek comment zaroor karen.
How to create userform in excel
How to create Advance userform in excel in hindi
VBA Userform in Excel in hindi
Create amazing userform in excel in hindi
VBA CODE
Private Sub L1_Click()
'lebel back color
L1.BackColor = &HC000&
L2.BackColor = &H8000&
L3.BackColor = &H8000&
L4.BackColor = &H8000&
'label font size or bold
L1.Font.Size = 14
L1.Font.Bold = True
L2.Font.Size = 11
L2.Font.Bold = False
L3.Font.Size = 11
L3.Font.Bold = False
L4.Font.Size = 11
L4.Font.Bold = False
'frame visible or not
Frame1.Visible = True
Frame1.Top = 50
Frame1.Left = 130
Frame2.Visible = False
Frame3.Visible = False
Frame4.Visible = False
End Sub
Private Sub L2_Click()
L2.BackColor = &HC000&
L1.BackColor = &H8000&
L3.BackColor = &H8000&
L4.BackColor = &H8000&
'label font size or bold
L2.Font.Size = 14
L2.Font.Bold = True
L1.Font.Size = 11
L1.Font.Bold = False
L3.Font.Size = 11
L3.Font.Bold = False
L4.Font.Size = 11
L4.Font.Bold = False
Frame2.Visible = True
Frame2.Top = 50
Frame2.Left = 130
Frame1.Visible = False
Frame3.Visible = False
Frame4.Visible = False
End Sub
Private Sub L3_Click()
L3.BackColor = &HC000&
L1.BackColor = &H8000&
L2.BackColor = &H8000&
L4.BackColor = &H8000&
'label font size or bold
L3.Font.Size = 14
L3.Font.Bold = True
L2.Font.Size = 11
L2.Font.Bold = False
L1.Font.Size = 11
L1.Font.Bold = False
L4.Font.Size = 11
L4.Font.Bold = False
Frame3.Visible = True
Frame3.Top = 50
Frame3.Left = 130
Frame2.Visible = False
Frame1.Visible = False
Frame4.Visible = False
End Sub
Private Sub L4_Click()
L4.BackColor = &HC000&
L1.BackColor = &H8000&
L2.BackColor = &H8000&
L3.BackColor = &H8000&
'label font size or bold
L4.Font.Size = 14
L4.Font.Bold = True
L2.Font.Size = 11
L2.Font.Bold = False
L3.Font.Size = 11
L3.Font.Bold = False
L1.Font.Size = 11
L1.Font.Bold = False
Frame4.Visible = True
Frame4.Top = 50
Frame4.Left = 130
Frame2.Visible = False
Frame3.Visible = False
Frame1.Visible = False
End Sub
Private Sub UserForm_Click()
End Sub
#DaoodComputerCentre
#UserformInExcel
#DaoodComputerAcademy
Негізгі бет Advance Userform in Excel in Hindi(Amazing video)कुछ नया सीखतें है जो यूट्यूब में पहले नही था Part-1
No video
Пікірлер: 246