November 2024
Intermediate to advanced
592 pages
15h 54m
French
Content preview from Livre de cuisine Excel
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Chapitre 18. Outils du développeur : Macros, VBA, contrôles et XML
Cet ouvrage a été traduit à l'aide de l'IA. Tes réactions et tes commentaires sont les bienvenus : translation-feedback@oreilly.com
L'onglet Développeur d'Excel contient des fonctions avancées que tu peux utiliser pour personnaliser et automatiser Excel. Par exemple, tu peux automatiser des tâches routinières ou répétitives, créer des fonctions personnalisées et utiliser des contrôles pour développer des applications basées sur Excel.
Les recettes de ce chapitre montrent comment utiliser ces fonctionnalités et comprennent les domaines suivants :
-
Enregistrement et exécution de macros, y compris l'utilisation de références absolues et relatives.
-
Écrire du code VBA - le langage de programmation intégré d'Excel - pour définir des macros et des fonctions personnalisées et travailler avec des événements.
-
Utilisation du classeur de macros personnelles et des compléments Excel pour partager des fonctions et des procédures personnalisées.
-
Utilisation de contrôles de formulaires, de contrôles ActiveX et de UserForms pour créer des interfaces utilisateur dynamiques* Importation et exportation de XML par la mise en correspondance d'éléments XML avec des cellules et des colonnes de tableaux Excel.
18.1 Afficher l'onglet Développeur
Problème
Tu veux utiliser les options du développeur telles que les contrôles de formulaire et les macros, mais tu ne sais pas où les trouver.
Solution
L'onglet Développeur Excel comprend ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.