Skip to main content

Intro To Macro: A simple Calculator

HELLO THERE!!!!
           How are you guys? I hope everyone is fine and happy always. This week I will continue my experimentation on the Excel Macro. I will introduce you guys on how to make a simple calculator using the Macro. The calculator will be able to add, subtract, multiply and divide. Before anything let's see what is needed for this experiment.
SOFTWARE:
1. Microsoft Excel

 Steps on how to open the developer tab and how to add Action X button is shown in the last week's post. Ok, now let's get straight to the point. First, add 4 Action X button in the Excel Spreadsheet.
4 Action X button; namely add,subtract,multiply and divide

Next, double click on the addition button ( make sure you are in the design mode). A Microsoft  Visual Basic for Application pane will pop up. In here, we can code our buttons to perform what we want.

The Visual Basic window Pane.



Now that's done, let's code the add button. Ok, the add button in this experiment will add number from the A1 cell with the number in B1 cell and produce the output in C1 cell. Simply put, A1+B1 = C1. The same thing will be done with other operations. The code for the add button is shown below:


Range("C1").Value = Range("A1").Value + Range("B1").Value


Range C1.value means the value in C1 cell. The code above takes the value in cell A1 and adds it with the value in cell B1 and writes the output in cell C1. Let's repeat the same process with the other operation buttons. Change the add button to subtract, multiply and divide for each of the button. For reference, I will show the code for other buttons below:

SUBTRACT:
Range("C1").Value = Range("A1").Value - Range("B1").Value

MULTIPLY
Range("C1").Value = Range("A1").Value * Range("B1").Value

DIVIDE
Range("C1").Value = Range("A1").Value / Range("B1").Value

Now, that's done. What to do next is to save the code and exit out of design mode to run the macros. The demo video for this experiment is shown below:





That's all from me Guys. See you next week and Happy Tinkering!!!
















Comments

Post a Comment

Popular posts from this blog

Arduino and Multi Function Shield: Pots,LEDs and buzzers

HELLO THERE!!!!!    How are you guys? I hope everyone is fine and in good mood always. This week, I continue my tinkerings with the Multi Function Shield. In this experiment, I used the potentiometer in the shield to control the LEDs in the shield. Without further wasting time, let's jump in straight to the experiment!! HARDWARE 1.ARDUINO UNO  2.MULTI-FUNCTION SHIELD SOFTWARE: 1. ARDUINO IDE CIRCUIT ASSEMBLY    The circuit assembly is fairly simple. Just attach the multi function shield on top of Arduino properly. Please attach the shield properly as failure to do so would cause the shield  not to function as intended. CODING THE ARDUINO: Let's refer to the multi-function shield image below: Referring to the image of the shield, it can be seen that the potentiometer (blue object near buttons) is connected to pin A0 (analog 0)     int pot = A0; //declaring the pot ...
Post a Comment
Read more

Mixing Color with RGB LED!!

HELLO THERE!!!     Hi everybody!! How are you guys? This week, I am going to share with you guys a fun experiment that I did during the weekends. The objective of this experiment is to use the RGB LED to output different colors. Without wasting further time, let's get into the experiment!! HARDWARE: 1.Arduino UNO 2. 3 Potentiometer 3. RGB LED ( I used the Keyes RGB LED) SOFTWARE: 1.Arduino IDE CIRCUIT ASSEMBLY:   By referring to the image below: The RGB LED has 4 pins, 1 GND, 1 pin each for the color red, green and blue. RGB LED                      ----------> ARDUINO  GND(- sign of the pin)                  GND R,G,B                                              Any Digital pin(I used pin 9,10 and 11) T...
Post a Comment
Read more

Arduino and Keyes KY-017 Mercury Tilt Sensor

HELLO THERE!!!     How are you guys? I hope everyone is fine and good as always. I am back in tinkering after a few months of hiatus( busy stuff :) ). So, today i would like to share with you guys on KY-017, which is a Keyes Mercury Tilt Sensor. KY-017 Sensor KY-017      The picture above shows the KY-017 Sensor from Keyes. It has 3 pins, A ground, A vcc, and A signal pin. If you look closely, there is a mercury ball inside the bulb like object. The mercury ball acts like a switch for this sensor. KY-017 Working Procedure: 1. When the sensor is not tilted, the mercury ball will be at the bottom of the bulb. This will complete the circuit and turns on the LED of the sensor. The output that is sent through the signal pin will be LOW. 2.When the sensor is tilted, the mercury ball will be at the top of the bulb(near at the sharper end). This will complete break circuit and turns off the LED of the sensor. The output that is sent through t...
Post a Comment
Read more