Creating Excel User Form – Using VBA Code!

Step One: Design User Form using excel visual basic, under developer tab.

Step Two: Create two labels and label them : “Name” & “Phone” Respectively

Step Three: Create “Submit” command button

Step Four: Write the below code between “Pravate Sub” of the command button and “End Sub” of the command button.

Refer to the image below and the code!

To Clear Text Boxes Use the Below Code