Hi friends today i like to share Advance Excel Tricks which make you fell proud. Today you can make Calculator with us. To make a calculator you just no need of any experiences. Just follow with this simple steps.
HOW TO MAKE CALCULATOR WITH EXCEL
First open your excel.
Go to run type excel and press enter.
After opening the excel press ALT + F11.
Then go to insert menu and click on UserFOrm.
After clicking on UserForm it shows like this.
Then click on ab|(text button) on Toolbax.
To make a blank field on UserForm1.
Then click on command button to make button of calculator.
Change it's name as your required.
To change it's name look at properties commandbutton in the left side of userform1.
After your design you need to apply code for each function.
Then just double click on commandbutton.
Double click on + command Button, it shows you
Type these code between Private Sub CommandButton1_Click() and End Sub.
On Error GoTo itcareworld
textbox3.text = Val(TextBox1.text) + Val(textbox2.text)
itcareworld:
After typed it will work for addition.
Now to make function another one like - just type textbox3.text = Val(TextBox1.text) - Val(textbox2.text)
itcareworld:
No need to type On Error GoTO itcareworld
It will work for subtraction.
You can use this code in Multiply and Divide just replace the sign.
You need five command box to complete your calculator.
In the last command box of CC you need to type this code to make function.
TextBox1.Text = ""
TextBox2.Text = ""
TextBox3.Text = ""
Now it is done enjoy it.
No comments:
Post a Comment