Advance Userform in Excel in Hindi(Amazing video)कुछ नया सीखतें है जो यूट्यूब में पहले नही था Part-1

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