Saturday 12 October 2019

Most Powerful Advance Option in Excel in Hindi Step by Step





VBA Code

Range("B2:F100").AdvancedFilter Action:=xlFilterCopy, _

criteriarange:=Range("o2:p3"), _

copytorange:=Range("i6:m6"), unique:=False


Monday 7 October 2019

MS Excel Userform Login ID password creation in Hindi Step by Step



Download File http://daoodcomputercentre.in/Softwar... VBA Password : password Login ID : admin@123 Login Password : admin VBA CODE USERFORM Private Sub CommandButton1_Click() If TextID.Text = "admin@123" Or TextPassword.Text = "admin" Then MsgBox "Unlock File Successfully" Application.Visible = True Unload Me Else MsgBox "Please Enter Correct ID or Password" TextID = "" TextPassword = "" End If End Sub VBA CODE WORKBOOK Private Sub Workbook_Activate() Application.Visible = False UserForm1.Show End Sub