Exit the Visual Basic Editor, enter the labels and data shown below into rows.MsgBox 'Your account is blocked' , vbCritical + vbOKCancel.Else If Username = u And Password p Then.MsgBox 'Username not matched' , vbCritical + vbOKCancel.Else If Username u And Password = p Then.Else If Username = u And Password = p Then.MsgBox 'Your Account temporarily locked' , vbCritical.If Username = u And Password = p And Cells (i, 3).Value = 'fail' Then.MsgBox 'Enter the Password ' , vbOKOnly.MsgBox 'Enter the username ' , vbOKOnly.MsgBox 'Enter username and password.' , vbOKOnly.If Trim (TextBox1.Text) = '' And Trim (TextBox2.Text) = '' Then.Right-click Sheet1 and click View code to write the code between Private Sub CommandButton1_Click () and End Sub.Right-click CommandButton1 and click View code.Drag a Command Button onto your worksheet.In the ActiveX Controls group click the Command Button.To place a command button on your worksheet and assign a macro:

The following figure shows the simple login form in Excel VBA. The User form we will create looks as follows.

This chapter teaches you how to create a simple login form in Excel VBA.

Click OK to save the selection changes.

The following figure shows the Customize Ribbon in Excel 2010.

Choose the Customize Ribbon button in the Excel Options dialog box.

The following figure shows the File tab and Options button in Excel 2010.

On the File tab, click the Options button.

This tab contains a variety of tools that allows development and customization of Excel macro applications. The Developer tab is not visible by default in Excel, we must configure it to show that tab.

In this chapter, learn how to turn on the Developer tab. Create a simple macro that will be executed after clicking on a command button. With Excel VBA you can automate tasks in Excel using what is called a macro. This article is mainly focused on creating applications using the Visual Basic for Applications (VBA) programming language.

Learn visual basic for excel 2010