Step 1 Go to developer tab

Step 2 Go to visual basic

Step 3 Go to thisworkbook

Step 4 select workbook

Step 5 select active

Step 6  write the coding

Step 7  create formate

Take a 2 label

Change caption and  backcolour

Take a text box and select second textbox 

Write * sign in passwordchar

create login button

Take a command button

Double click login button and start coding