Traducir el blog
International Virtual Keyboard in Excel
Download for free at the end of this article the renewed version of the International Virtual Keyboard most complete that exists worldwide made entirely in Excel.
It has all the functions of a few keyboards in a single Graphical user interface. Check it out for yourself!
This virtual keyboard is used for touch screens or as a substitute, if the physical keyboard breaks down. It is also useful for learning and testing various keyboard layout in several languages or in the Dvorak keyboard layout.
You can even create your own keyboard! adding a column in the 'Teclas' sheet.
10 years ago I allowed myself the audacity to modify the original idea of a virtual keyboard of a genius of macros, to make it international.
The idea came from Macro Antonio, a VBA macro expert and friend on Excel forums, who posted his version of a virtual keyboard.
Another of the best Excel forum members I had the pleasure of meeting was verzulsan, who improved the keyboard to repeat the keys in "machine gun" mode, and I made the international version and posted it on my blog:
International virtual keyboard | #ExcelPedroWave
3 weeks ago, a follower of my YouTube channel warned me that the keyboard "only works on old 32-bit systems", which made me review it and I decided to update it, adding the PtrSafe keyword to make it work in 64-bit Excel.
In addition, I myself had written a note in said article: "The Alt key doesn't generate the encoded characters, for example Alt+21 = §"
Then I realized that a follower of the blog had commented 6 years ago that: "Fonts on the page is blank, the fonts are not visible."
So this International Virtual Keyboard, made entirely in Excel!, incorporates the following new features:
- Compatible with any 32-bit and 64-bit version of Excel.
- Insert symbols and characters with Alt + code, holding down the Alt key while typing the character's decimal code on the numeric keypad, for example Alt+21 = §, explained in: Insert ASCII or Unicode symbols - Microsoft Support
- List the types of text fonts with a dropdown ComboBox that allows you to choose the type of text font: About Microsoft Typography | Microsoft Learn
- New dropdown ComboBox with default Zoom: 100; 125; 150; 175; 200. With the ScrollBar you can continue changing the Zoom.
This is how the revamped International Virtual Keyboard looks like with different keyboard layouts in several languages:
Instead of pressing the keys of a physical keyboard, try pressing the keys of this International Virtual Keyboard, with the following functions:
- Design the keyboard doing it entirely in Excel, with a user form: UserFormTeclado built dynamically with VBA macros.
- Translate the keyboard to multiple languages: Español, Latinoamericano, English, Français, Italiano, Deutsch, Português, with the possibility of adding more languages on the 'Teclas' sheet, or even your own custom keyboard.
- Change the layout of the keys: QWERTY, QWERTZ (German), AZERTY (French) and Dvorak keyboard layout in Spanish and English.
- List all Windows text fonts and format the text according to the chosen font.
- Save in the 'Personal' sheet the zoom and the last font, size and text properties.
- Show the symbols of the special keys according to the international standard ISO/IEC 9995.
- Include the special keys: Enter, Tab, Ctrl, Alt Gr, Shift, Caps Lock, Num Lock, Windows key, Menu, Insert, Delete, Home, End, Page Up, Page Down and cursor movement arrows.
- Operate the numeric keypad as a basic calculator.
- Hide or show the numeric keypad.
- Expand the text box with double click.
- Other minor improvements, such as positioning the keyboard on the screen.
- Insert ASCII and Unicode symbols with the key combination Alt + decimal code. This function is explained below.
To enter ASCII and Unicode characters:
- On a physical keyboard, hold down the Alt key and type the decimal code of the ASCII or Unicode character with the numeric keypad. When you release the Alt key, the special symbol appears.
- On the virtual keyboard, press the Alt key (which remains marked), write the decimal code of the ASCII or Unicode character with the numeric keyboard. The Alt key is pressed again and the special symbol appears.
Codes with the Alt key are divided into 3 groups:
- 255 BIOS ASCII codes: Alt+1 to Alt+255
- 128 ANSI codes or Windows Alt codes, with the number 0 in front: Alt+0128 to Alt+0255
- 149186 Unicode codes, with the decimal code of the 1 to 6 digit Unicode character. It should be noted that in this virtual keyboard you cannot enter hexadecimal codes, only decimal codes. For example: Alt+129412 represents the Unicorn symbol: 🦄 (hexadecimal code: 0x1F984)
Some interesting pages about Alt key codes:
List of Unicode characters - Wikipedia
ALT Codes | Windows ALT Key Codes for Characters & Symbols (altcodeslist.com)
In this video tutorial I explain how to use this International Virtual Keyboard.
Select your language caption to understand the video.
Download version 2.0 from one of these links:
- Microsoft OneDrive: International Virtual Keyboard - Teclado Virtual Internacional PW2.xlsm
- Sites Google Drive: International Virtual Keyboard - Teclado Virtual Internacional PW2.xlsm
The downloaded file's macros are blocked by default. To unlock the macros you must modify the file Properties following these instructions:
Macros from the internet will be blocked by default in Office - Deploy Office | Microsoft Learn
Open the file and press the button: Enable editing when the PROTECTED VIEW notice appears.
Press the button: Enable content when the SECURITY WARNING appears Macros have been disabled
The sheets are protected without a password and the VBA project is not protected, so you can study and analyze all the code. You can even modify it respecting these license:
Creative Commons — Attribution-NonCommercial-ShareAlike 3.0 Unported (CC BY-NC-SA 3.0)
Compare this keyboard with the Google virtual keyboard on this page:
Google's virtual keyboards are built into Google Translate, for example:
Pressing on the keyboard (within the red rectangle) selects the text input tool, for example in English: ⌨️ English; ⌨️ English DVORAK; ✏️ English touch writing.
The main advantage of Google's virtual keyboard over mine is that when you press the physical keyboard keys, it sends the virtual keyboard keys instead.
It will be an issue to consider if I decide to improve these Virtual Keyboard.
In the meantime you can read my previous articles on keyboards and special characters in Excel from here:
Mi lista de blogs
-
Regresos 14 – (2) Bases de cuatro cubos con suma cero - En la anterior entrada estudiamos las sumas de cubos cuyas bases suman cero. En esta otra ampliaremos el estudio a cuatro cubos. *Sumas con cua...Hace 8 horas
-
Problema 2: Errores en la nube de OneDrive - 🔝*To translate this blog post to your language, select it in the top left Google box. * Este año ha comenzado con dos problemas detectados en Microso...Hace 1 día
-
Crea con IA tablas Excel de ejemplo - Crea con IA tablas Excel de ejemplo para practicar y simplificar tareas de buscar datos o crearlos. A veces, encontrar el conjunto de datos perfecto para...Hace 2 días
-
What Does #### Mean in Microsoft Excel? - If you’re wondering what does #### mean in Excel, read this Microsoft Excel guide until the end, and learn all the ways Excel uses the pound or number sign...Hace 2 días
-
Cómo graficar totales de una tabla dinámica en Excel - Las tablas dinámicas son una de las herramientas más poderosas en Excel para organizar y analizar grandes cantidades de datos. Sin embargo, cuando necesi...Hace 3 días
-
OBTENER LA TENDENCIA EN POWER APPS CALCULANDO LA PENDIENTE - Hola a todos, He estado estos días implementando un nuevo input en el borrador de un proyecto de Apps que estoy creando. Se trata de … La entrada OBTENE...Hace 3 días
-
3DFrame-NLGeom - The VBA version of the 3DFrame spreadsheet has now been updated to allow geometric non-linear effects to be included. The new version can be downloaded fro...Hace 5 días
-
Fin - Llevo tiempo pensando esta entrada y no sé que decir. Analisis y Decisión nació en 2008 y no ... Leer más »Hace 1 semana
-
Validación de Datos en Excel: de lo Básico a lo Avanzado - En Excel, uno de los errores más comunes es dar por sentado que sabemos lo básico. Muchas personas que se […] The post Validación de Datos en Excel: de l...Hace 1 semana
-
📊🔎 Cómo usar SI y UNIRCADENAS para manejar múltiples resultados en un búsqueda - ¿Cómo buscar múltiples resultados en Excel y unirlos en una sola celda?Si has trabajado con Excel, seguramente conoces la función BUSCARV, que permite enco...Hace 2 semanas
-
Happy Excel Day 45678 - Where does the time go? Two years ago, we were celebrating Excel Day 45000, and suddenly it’s Excel Day 45678! Do you have any special events planned? If n...Hace 4 semanas
-
FREE 4 Hours Complete Excel Course - FREE 4 Hours Complete Excel Course Here is a FREE, complete end-to-end Excel course to help you learn all the key and essential aspects of Microsoft Exce...Hace 1 mes
-
Análisis DAFO (FODA, DOFA) las decisiones con Excel - Para conocer la situación de una empresa, proyecto o persona, recurrimos al análisis DAFO (FODA, DOFA) en la toma de decisiones con Excel. El los años sese...Hace 3 meses
-
Color, Conditions, and Copilot: How to save time using conditional formatting with Copilot in Excel - Hi everyone, this is part 11 in a series of posts to show you some of the things that are possible to do with Copilot in Excel. *What is conditional f...Hace 3 meses
-
4 ejemplos de utilización de validación de datos con fórmulas - Ya sabes que la herramienta de Validación de datos es de gran utilidad para controlar y restringir la introducción de datos y así, asegurarte de…Hace 5 meses
-
How To Predict Bearing Life With Excel - When you work in mechanical engineering, understanding the reliability and performance of bearings under various conditions is crucial. Bearings are the co...Hace 5 meses
-
-
TikTok’s search evolution - 2 in 5 Americans use TikTok as a search engine. Nearly 1 in 10 Gen Zers are more likely to rely on TikTok than Google as a search engine. More than half of...Hace 10 meses
-
Unblocking and Enabling Macros - When Windows detects that a file has come from a computer other than the one you're using, it marks the file as coming from the web, and blocks the file....Hace 1 año
-
Office Scripts: Trabajando con Tablas - [image: Office Scripts: Trabajando con Tablas] Me he dado cuenta que últimamente solo escribo de lenguaje M (es mi pequeño vicio)... pero hay que liberar l...Hace 2 años
-
Hello world! - [image: Hello world!] Welcome to WordPress. This is your first post. Edit or delete it, then start writing!Hace 2 años
-
La importancia de saber mecanografía en 2022 - [image: Resultado de imagen de mecanografía viñeta escribiendo a máquina] Según la RAE, la mecanografía es el arte de escribir a máquina. Hace unos cuantos...Hace 2 años
-
London Excel Meetup Workbooks - The workbooks used in my presentation on “Analytical and Interactive Dashboards in Excel” at the London Excel Meetup, September 3, 2020Hace 4 años
-
Cálculo de jornada que termina al día siguiente (Power Query) y despedida - [image: Cálculo de jornada que termina al día siguiente (Power Query) y despedida] Este blog se ha ocupado de cálculos de tiempo con bastante intensidad, c...Hace 4 años
-
Agenda Perpetua Excel Calendario Perpetuo - Saludos a los ingenieros y a todos los que forman parte de nuestra comunidad de planillas Excel para ingeniería civil, ya se vienen las fiestas navideñas y...Hace 5 años
-
International Keyboard Shortcut Day 2019 - The first Wednesday of every November is International Keyboard Shortcut Day. This Wednesday, people from all over the world will become far less efficient...Hace 5 años
-
Welcome, Prashanth! - Last March, I shared that we were starting to look for a new CEO for Stack Overflow. We were looking for that rare combination of someone who… Read more "W...Hace 5 años
-
Visualize parts and whole - combine clustered column and stacked column charts - *Inga: Disa what?* *Igor: -ppeared.* by The FrankensTeam ------------------------------ Really it was 3 years ago we posted our last article? *Freddy: Th...Hace 5 años
-
Salvador Sostres, analfabeto profesional - Los nuevos tiempos traen nuevas profesiones. Internet, además, ha revolucionado el mundo del periodismo y la palabra escrita. Adaptarse o morir, ese es el ...Hace 6 años
-
Planificación de compras - 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 p...Hace 12 años
-
-
-
-
-
-
-
-
-
No Response to "International Virtual Keyboard in Excel"
Leave A Reply
Indícame las erratas que encuentres y qué es lo que te gustaría ver en los próximos artículos.