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

Arduino Beginner Experiments: Arduino and Light Blocking Sensor

HELLO THERE!!!     How are you guys? I hope everyone is fine and in a good mood always. This week, I would like to share with you guys my experiment on Arduino and Light Blocking Sensor. The objective of this experiment is to receive feedback from the sensor ( Digital and Analog) What is Light Blocking Sensor?      A linear hall sensor is a type of sensor which responds when the sensor is blocked out from light. The sensor is different for LDR's as LDR's responds to the amount of light it received while the light blocking sensor responds if the light is blocked out or not from the sensor.It can be used for both digital and analog measurements. HARDWARE: 1.Arduino UNO 2. Light Blocking Sensor SOFTWARE: 1.Arduino IDE CIRCUIT ASSEMBLY   Let's refer to the image of the blocking sensor below: The Connection of the Sensor to the Arduino is shown below: SENSOR  ----->       ARDUINO Signal   ...
Post a Comment
Read more

Arduino Tinkering : Controlling multiple LED with multiple potentiometers

HELLO THERE!!!!            How are you guys? I hope everyone is fine and well always. For this week's post, I would like to share with you guys a simple tinkering on Arduino, LED, and potentiometers. The objective of the experiment is to light up different amount of LED's with different intensity by controlling two potentiometers. Before starting, of course, we need to know what items are needed. The items needed are: 1. Arduino UNO   2. 4 to 5 LEDs 3. 2 Potentiometers The software used in this experiment is: 1. Arduino IDE. Now that all the hardware and software are obtained, let's go to the schematics of the circuit. The circuit is quite simple actually. The long legs of the LED's were connected to PWM pins while the shorter legs were connected to ground. The potentiometers however have three legs. The middle leg is connected to the analog pins (A0, A1) while the other two legs were connected to 5V and GND respect...
Post a Comment
Read more