### How to make Excel calculators

Posted on viernes, mayo 06, 2011 by Pedro Wave

In the previous article on Calculating minds I was showing a calculator written in Excel and now I shall explain how to make calculators in Excel.

New enhanced calculator

If you like the calculations as well as I sure that you will like the new calculator with these improvements (Version 4):
1. Calculator mode without floating keys.
2. New calculator beta 5, with all trigonometric functions.
3. New full calculator 6, with all 67 function keys.
4. Softkeys or keyboard equivalents for all keys.
5. Improved tooltips with less flicker or blink.
6. International geolocalized calculator.
7. Information and help translated into 6 languages​​: English, Spanish, French, Italian, German and Portuguese.
8. Display the calculator in 56 colors.

ATTENTION: To change the display color, choose a color in row 1.

Be sure to try Calculator without keys mode, selecting a keypad number 7 and up. If you know or you learn all the tooltips or the physical keyboard equivalents you will be able to calculate pressing physical keys such as the blind method of typing. For example, the numbers e and pi are displayed by pressing E and P keys, respectively.

How it was done the floating keys calculator

This calculator is initially opened without a floating key, ie without any shape drawn initially by default, each key forms is generated dynamically when you select a calculator number.

If you test it, you will find it much easier calculating with it than with the first general purpose electronic calculator in the world, the ENIAC, which lasted about 12 years since the contract sign until its final shutdown, but I hope you do not use it to calculate the trajectories of projectiles and hydrogen bombs.

This workbook

When it is opened run the macro Workbook_Open that sets the range codPais of the "Cod" sheet in cells B2:C220 linking the country dialing code with a value for your language: 1-English 2-Spanish; 3-French 4-Italian 5-German 6-Portuguese, etc. This value is stored in the BM48 cell of the "Calc" sheet.

In order for the function key supports OnKey "/" such as operation of dividing and not its effect by default to open menus, this property must being changed:
`Application.TransitionMenuKey = ""`

If AO48 = 1 then calls macro ActivaTeclado and dibujaTeclas with the keyboard number in cell BN13.

Workbook_BeforeClose calls DesactivaTeclado and re-modify the default value:
`Application.TransitionMenuKey = "/"`

Calc sheet

Worksheet_Change event launches by changing the value of these cells:
• AC48 to activate o deactivate Tooltips, calls to dibujaTeclas
• BM48 change language and if AC48 = 1: dibujaTeclas
• BN13 calls to dibujaTeclas with another keyboard number

Worksheet_SelectionChange runs in two cases:
• When Tooltips are enabled and active cell is in column 101, by reading the value of the active cell that contains the equivalent key down and calling macro tecla
• If the row is the one and the columns between 21 and 76, change the display color

Module modAyuda

AyudaCalc macro is changing the text and the position of the giant key help in 9 steps, calling textoAyuda looking translation in the "Languages​​" sheet with the VLOOKUP function.

Module modCalc

This module contains the macro that does the calculations themselves: tecla passing the key value of the pressed key buttons virtually on the spreadsheet or really in the physical keyboard.

Each digit of a number is forming the number visualized on the display.

Changes to a darker color the last key pressed, and if it is an operation with two operands, the operator is diffuses in yellow to remember what was the last operator pressed.

Opera function performs operations for operators with two operands, such are: add, subtract, multiply, divide, percentage, module, logarithms and powers in y base.

Additional functions of the calculator are:
• valTrigo performs trigonometric functions with degrees and radians.
• u_fact calculates the factorial of an integer.
• swapTeclas swaps the two operands.
• visTecla hide or show a key.
• grabaTeclado to create another sheet with a new key number, calling posTeclas
• Traduce passing a code gets a translation into one of 6 languages.

The routine ActivaTeclado runs Application.OnKey function once for each key of the "Teclado" sheet by assigning a code in column D to a procedure in column E, getting physical keys assigned to the virtual keys on the calculator.

DesactivaTeclado makes the opposite assigning default code to each physical key.

With extensibility may include programmatically in VBE, Tools, References, the reference to Microsoft Visual Basic for Applications Extensibility 5.3 needed to dynamically create procedures calling IncluyeSubModulo to be executed only once, and is therefore commented in the macro ActivaTeclado. Each of these nearly 100 procedures automatically generated then calls macro tecla  with its key type argument, such as in this example:
```Public Sub TKPorcentaje()
tecla ("%")
End Sub```

Module modTeclas

Routine dibujaTeclas is reading from a "Teclasn" sheet, where n is a keyboard number from 0 to 100 (0 to 6 per default), each of the keys that make up the keyboard and draw them according to their properties: name, text, font, color, size, style, top and left position, width, height and visible.

posTeclas routine creates a new "Teclasn" sheet when you want to record a new keyboard.

creaTecla add a shape calling AddShape with msoShapeBevel type with the appearance of a button, similar to a key.

tipTecla function gets the text from the Tooltip of a key from the column F of the "Teclado" sheet with its operation and, in parentheses, their corresponding equivalent physical keys, eg: Random number (A) so that pressing A key calculates a random number.

How to make calculators

This video explains how to use and create Excel calculators.

The best is the ability to create new calculators, customizing the shape of keys and expanding and improving the graphical user interface to the taste of each, without knowing programming, just to know how to change text and size of keys shapes and knowing to drag and drop buttons, which is learned in two minutes watching the above video.

Comparison with the Windows Calculator

As that seems to Micro\$oft Calculator, nothing is further from my intentions. Of the 8 calculators that I supply, the only one I wanted to look like the Micro\$oft Windows is No. 2 and only in its appearance not in their calculations  that leave a lot to be desired for several errors that hides: Incorrect Calculator Results When You Use the Percent Key Test in the standard and scientific Micro\$oft calculator: 4 sqrt - 2 = -8.1648465955514287168521180122928e-39 (any calculator gives 0) 50 + 25% gives 12.5 (others calculators giving 62.5) 50 [Inv] [Hyp] sin give 4.6052701709914238266212392672083. The arc hyperbolic sine in degrees and radians gives the same value always in radians, when in degrees should give 263.8625443153 0 x^y 0 = 1 most calculators give a value 0 or better unspecified or undefined, but Google calculator also gives 1 with 0^0. See: Wikipedia Zero to the zero power The scientific mode before Windows 7 is not the key square root [sqrt], which is a real mess. When switch between standard and scientific Micro\$oft calculator, calculations are lost, which does not happen with my Excel floating calculators. I have much more reason to never use this impoverished calculator...

Running this calculator

To run with CTRL + SHIFT + C shortcut keys in a shortcut created on the desktop with this destination:

`"C:\Archivos de programa\Microsoft Office\Office14\EXCEL.EXE" "C:\Excel\Calculadoras\CalculadoraTactilPW4.xls"`

Keyboard shortcuts for Windows The Windows calculator I run with ALT + SHIFT + C and has a very large stick which makes very small!!! and that would not be maximized or enlarged?!!! which is why I started ruminate on the idea of making one in Excel, that it has an excellent Zoom...

#### No Response to "How to make Excel calculators"

Dime si te gusta lo que lees y, si no te gusta, dime por qué. Tengo habilitada la moderación de comentarios. Tu comentario se publicará pronto.

Tell me if you like what you read here and if you don't like, tell me why. I've enabled comment moderation. Your comment will be published ASAP.

## Mi Lista de Blogs- My Blog List

• - One of the coolest features of Excel 2016 is *forecasting. *Today, let's understand how it works with a sample data set. Watch below video to understand fo...
Hace 7 horas
• - Mostrar los números positivos con signo más y los negativos con menos, con diferentes opciones para mostrar en Excel el signo más (+) en números positivo...
Hace 11 horas
• - In the previous post arrays were created in Python and passed to a Fortran dll as ctype pointers. The data written to these arrays in the Fortran routines...
Hace 14 horas
• - Aunque no es una función muy empleada (por suerte cada vez más) la función *INDICE* siempre tiene guardado un as bajo la manga, y siempre nos sorprenderá. ...
Hace 23 horas
• - Outlook is expanding the availability of two new experiences to do just that—Focused Inbox and @mentions. These new experiences add to several recently r...
Hace 1 día
• - Some time back I setup a (not too serious) survey (based on Excel online of course) to see what people thought were the best (most heroic) and worst (most ...
Hace 1 día
• - Like many of you, I grew up attending Sunday school. One of my memories of that experience involves a song that was a favorite among us kids: “Deep and Wid...
Hace 1 día
• - Vamos a bailar a ritmo de rock and roll. Sartana, nos trae la tercera entrega de éste juego dedicado al museo de la fama del Rock. Si jugamos los otros d...
Hace 2 días
• - Title Problema Nos proponemos crear el producto cartesiano de dos tablas en Ms Access, todas las posibles combinaciones de dos tablas (cross join o combin...
Hace 2 días
• - Por ejemplo, el típico caso: tenemos un rango de datos y queremos concatenarlo. Como ya sabes, la función concatenar requiere que le pases las celdas que s...
Hace 4 días
• - […] La entrada Cómo el diagrama de Gantt en 1 minuto en Excel 2010 y 2007 aparece primero en Funcionarioseficientes.
Hace 5 días
• - If you have an Excel workbook with lots of tables and pivot tables, it can be hard to remember what they’re named, or what source data they're using. To ...
Hace 6 días
• - Os dejo un vídeo al que le he incluido subtítulos en español. Como científico teórico se supone que debo odiar y/o despreciar la ingeniería, como She...
Hace 1 semana
• - The T-Ledger Account Sheet provides you with a free graphic representation of your general ledger accounts in an easy to read format. The template is eas...
Hace 1 semana
• - This Excel tutorial explains how to automatically refresh pivot table using Macro / VBA and Pivot Table Options. Excel automatically refresh pivot table ...
Hace 1 semana
• - Plantilla en Excel para calcular la gratificación por Fiestas Patrias 2016: El día viernes 15 de julio fué el último día de plazo para que las empresas del...
Hace 1 semana
• - The developer tool suite offered by Microsoft for Excel is currently a set of three complimentary technologies: Visual Studio Tools for Office (Dot Net) Ap...
Hace 2 semanas
• - You are a brilliant scientist and you just made an amazing discovery. You want to announce it to the world. So you prepare a few slides and decide to use...
Hace 2 semanas
• -
Hace 2 semanas
• - This is a quick post to answer this rather common question from the forums: I have a worksheet that has data in a particular arrangement and a chart that...
Hace 3 semanas
• - This is a quick post to answer this rather common question from the forums: I have a worksheet that has data in a particular arrangement and a chart that...
Hace 3 semanas
• - Before I start, a couple of announcements. First of all, please accept my apologies for the time between posts. A combination of workload and a family bere...
Hace 3 semanas
• - *Como todos los años, al llegar julio interrumpimos la publicación de entradas hasta septiembre. Esto nos sirve para descansar y planificar la siguiente ...
Hace 3 semanas
• - Here’s a report for a high volume, low margin product. Because the profit is so much smaller than sales and costs, column D is narrower than columns B and ...
Hace 3 semanas
• - Entrada núm: 2 of 2 de la serie Mapas con Excel Lección 1: Preparar datos: Nombres de Regiones, Valores, Formas Presentamos la tabla de datos que se quie...
Hace 3 semanas
• - RefTreeAnalyser 2.0 has just been updated. I have added an option to display your formula as a mathematical equation.
Hace 5 semanas
• - En el pasado hemos hablado de las bondades de los estilos en Excel. Pero al lado de las bondades convive un problema como el que me consulta un lector: Peg...
Hace 5 semanas
• - Muchos de los estudiantes de programación se sienten intimidados al escuchar la palabra Array (matriz) y evitan en muchos casos el uso de los mismos en sus...
Hace 5 semanas
• - Dada un Función f: IR ----> IR, tal que f(x)=5x+16. ¿Cuál es el valor de f(3) + f(1)? A) 31 B) 21 C) 4 D) 52 E) 62 *Respuesta:* *Que sea de IR ----> IR, ...
Hace 5 semanas
• - *Inga: You know, there's something I've been meaning to ask you. In the transference, the monster got part of your wonderful brain. But what did you ever...
Hace 5 semanas
• - [image: Tip: How to find missing values with COUNTIF] In this video, we'll take a look at how to use the COUNTIF function to solve a common problem: how t...
Hace 5 semanas
• - *Date Units on the X Axis- Excel*I was working on a dashboard in Excel 2016 and I ran into something a bit frustrating. So, I thought I would share it sinc...
Hace 5 semanas
• - Saludos a todos los miembros de nuestra Web de *Planillas Excel Para Ingeniería Civil*: *Civil Excel*, luego de un tiempo sin publicar aportes compartimos...
Hace 1 mes
• - How to use R, a Tableau connection to R and Calculated Fields to store and load the underlying data of a defined Tableau View in a Database or Text File (p...
Hace 1 mes
• - One more thing… It’s been awhile since we launched a whole new product at Fog Creek Software (the last one was Trello, and that’s doing pretty well). Tod...
Hace 1 mes
• - Limpiar caracteres no numéricos en Excel Aprende a emplear un conjunto de técnicas que te permitirán limpiar caracteres no numéricos en Excel, de forma p...
Hace 1 mes
• - En el trabajo diario nos encontramos con diferentes situaciones que requieren que realicemos validaciones y conciliaciones. Un ejemplo de ello son las conc...
Hace 2 meses
• - Last May, we added some expressions to our templating language to make it easier for you to customize your blog’s look and feel. These new expressions prov...
Hace 2 meses
• - Have you ever sent an Excel report out to your audience just to find out that it prints on 20 pages? To avoid that embarrassment, I routinely adjust the pa...
Hace 2 meses
• - So this just happened. BigQuery integration with Sheets!. This is great; now you can use a spreadsheet as a federated datasource for BigQuery, and therefor...
Hace 2 meses
• - One more assistance Is Closely Inspected. Loser or Top Service? Collaboration is a versed writing company which has won over – huge number of people. Young...
Hace 2 meses
• - Demand-Driven MRP in an Excel Planning System. See a demo system and get a free, fully-functional copy of the DDMRP planning system in Excel.
Hace 2 meses
• - Just set up meetings, then cancel them. You'll be doubly happy.
Hace 3 meses
• - I seems to have inadvertently deleted my Picasa Web folder. As a result all the graphs in the previous posts are missing. I will over the next month or so ...
Hace 3 meses
• - *Obligación de presentar los libros contables en el Registro Mercantil* Para la mayoría de las empresas, (aquellas cuyo ejercicio fiscal termina el 31 de ...
Hace 3 meses
• - La función ESTEXTO en inglés ISTEXT nos permite saber si lo que esta escrito en cierta celda a la que hace referencia es un texto o no lo es. Si es texto d...
Hace 4 meses
• - Blogger templates month by month, year by year keep getting better and better, for the first two months of 2016 we offers you 10 excellent examples of Blog...
Hace 4 meses
• - Here’s a font geek post exploring the typography of Star Wars through the years.
Hace 5 meses
• - I recently contributed to the article on MRC’s Cup of Joe Blog called 7 harmful business dashboard mistakes. I’ll excerpt a version of what I said below, b...
Hace 5 meses
• - Hi, Recently I came across a great post about SQL Performance Tuning Tips n Tricks, which outlines a good deal of information across all the common feature...
Hace 6 meses
• - Calendario Perpetuo en ExcelPara comenzar bien el año 2016 nada como tener a mano un calendario anual completo y otro mensual escritos en Excel, con fotos ...
Hace 6 meses
• -
Hace 7 meses
• - En el artículo anterior, vimos un ejemplo un poco rebuscado, para determinar en qué columnas (A, B, C…) se encontraban una serie de valores que teníamos en...
Hace 7 meses
• - Free Streaming Victoria in HD FormatNow you can see Victoria in best video format with duration 140 Min and has been launched in 2015-06-11 with MPAA rati...
Hace 8 meses
• - Hey just a note to say that this website will be shutting down on November 1st, 2015. I don't really program in VBA anymore, I'm more into mobile now (mo...
Hace 9 meses
• - Macro to hide and unhide the rows on comment text Option Compare Text Sub filteroncomments() Dim commenttext As String Dim commentrng As Range Dim cl As ...
Hace 10 meses
• - [image: Road Transport Emissions Evolution In Urban Areas; The Case Of Thessaloniki, Greece] ------------------------------ About -------------------------...
Hace 10 meses
• - PUP v6 will be discontinued in a few weeks. This is the older version for Excel 2000, 2002, and Excel 2003. If you purchase PUP v6, you will be eligible ...
Hace 10 meses
• - [image: ASAP Utilities » Numbers & Dates » Convert unrecognized numbers (text?) to numbers]Save 5 minutes a day by using ASAP Utilities to quickly fix the ...
Hace 11 meses
• - Hola, estimados y queridos visitantes de *este malagradecido blogero excelmaníaco*. Vuelvo luego de meses y meses de inactividad... espero no abandonar nun...
Hace 1 año
• - Hola! Este es un tema bastante buscado y solicitado por la red, hay diferentes formas de obtener buenos resultados, pero este aporte tiene la diferencia q...
Hace 1 año
• - Para poner borde a imágenes de una entrada utilizamos, dependiendo de la ubicación, los siguientes códigos: Imagen a la izquierda <div class="separator...
Hace 1 año
• -
Hace 1 año
• - A new cloud folder is available for downloads. Here. you will find the following sub-folders : - Add-in files for Excel 2007 to 2013 - 32 bits - Add...
Hace 1 año
• - How to calculate Pi by throwing Hotdogs in Excel. This is an implementation of Buffon's Needle in Excel.
Hace 1 año
• - ------------------------------ EVITAR MOVIEMIENTOS DE PANTALLA (MACRO) VBA Para evitar que durante la ejecución de una macro se vean todos los movimient...
Hace 1 año
• - Over at Data Pig Mike shows us how to crack the VBA Password. I think it’s always been a bit of an unwritten rule that those of us in the club, never passe...
Hace 1 año
• - Dear George I agree with most of your points, specifically the 7th point of "why excel?". I have done my research in stochastic concept recently, started d...
Hace 1 año
• - Hola: Respondiendo a este post: Hola! Alguien sabe como puedo crear una macro en word para guardar un documento en pdf cuyo nombre sea la primera linea...
Hace 1 año
• - José Luís Morato es probablemente una de las personas más activas en el ámbito logístico en la Comunidad de Madrid. Sea como organizador, ponente, profesor...
Hace 1 año
• - A partir de septiembre dejaré de publicar nuevos contenidos en este blog, ya que estreno web oficial en la que agruparé todos los contenidos con mi perfil ...
Hace 1 año
• - ExcelCalcs is a community who share an interest in making calculations with MS Excel. Use our XLC add-in for Excel to display cell formulas as easily reada...
Hace 2 años
• - L'événement sportif de l'année, c'est pour bientôt : le 12 Juin 2014. Téléchargez ce fichier pour faire vos simulations ou bien pour lancer un concours de ...
Hace 2 años
• - Once a month here in Atlanta, we invite a few folks from the data community together to discuss the “data value chain” and sharpen each other’s thinking in...
Hace 2 años
• - Adobe’s Portable Document Format or simply PDF is unavoidable and necessary in today’s age of electronic file sharing, storing and exchanging. When you w...
Hace 2 años
• - Training courses for Outlook 2013 Beginner *Calendar basics* Watch these videos to get familiar with the calendar in Outlook 2013. You can keep things si...
Hace 2 años
• - Todo el mundo sabe lo versátil que es Excel, que se puede hacer casi cualquier cosa con este programa; seguramente en esta flexibilidad radica su éxito, ...
Hace 2 años
• - Hola a todos!!! Tengo un pequeño problema y espero puedan ayudarme a resolverlo. Hice un gráfico de dispersión con lineas suavizadas y marcadores,...
Hace 2 años
• - Esta es una continución a una entrada anterior con algunas funciones que facilitan la lectura de un libro de Excel en Python. Un problema frecuente que se ...
Hace 2 años
• - Los últimos post del blog sobre Excel, están siendo dedicados a cómo construir un cuadro de mando. Una herramienta que te permite condensar la información ...
Hace 2 años
• - A great exercise. You must see it... *http://www.excelcharts.com/blog/excel-dashboard-catchment-area/*
Hace 3 años
• - A common requirement is to generate a set of random numbers that meet some underlying criterion. For example, a set of numbers that are uniformly distribut...
Hace 3 años
• - Las *Tablas dinámicas* sirven para resumir tablas de datos y obtener subtotales, promedios, porcentajes, máximos, mínimos... Pero, antes de hacer nada debe...
Hace 3 años
• - The post pcfix appeared first on Ejemplos y trucos Excel y VBA - XLTODAY.
Hace 3 años
• - Hé oui! Le site du Grand Chaman Excel a maintenant une nouvelle adresse. Il y a eu peu d'activités sur mon blog au cours des dernières semaines. La raison ...
Hace 3 años
• - We're not sure if you've ever experienced this problem (we ourselves hadn't) - but hey! we're big believers in the Boy Scout motto. "Be prepared" is advi...
Hace 3 años
• - About once a week I see a post on the Tableau Forum that ends up being a queue or utilization problem. Let me give you some examples: I have work orders on...
Hace 3 años
• - Aún no hemos asimilado la llegada de Office 2010 y ya está disponible para descargar la versión de prueba de Office 2013… No quisiera parecer inmovilista, ...
Hace 3 años
• - Realizar una lista con los productos que necesitamos y que formarán parte de nuestra cesta de la compra nos ayuda a *encontrar la combinación de bienes pr...
Hace 3 años
• - This is an animated model of a Buck voltage switching regulator in MS Excel 2003. Besides real time control of common parameters such as switch ON resista...
Hace 4 años
• - I am sharing Excel Addin for converting Numbers to Words. I keep getting mails / comments where people are not able to install the VBA code shared in my ea...
Hace 4 años
• - Top 10 Tallest Buildings in the world Hi friends, today i am going to list the top 10 tallest buildings in the world, made till now.But as its not easy to ...
Hace 5 años
• - Es el objeto siguiente a *Application y Workbook *en el orden jerárquico de *Excel*. El objeto *Worksheet *recoge todos los métodos, propiedades y eventos ...
Hace 5 años
• - This model is useful to study the relationships between two variables (explanatory and explained), for example: amount depending on the price, sales in te...
Hace 5 años
• - Over the past several months, many emails and messages have come to us asking about earlier MrExcel Podcasts. In an attempt to make even the earliest episo...
Hace 6 años
• - A meeting of the above group will take place on Wednesday 1st and Thursday 2nd April 2009 in London. This FREE event has some fantastic speakers from the E...
Hace 7 años