Category: Talk about Excel VBA

Announcement of Python in Excel (2023-08-22)

1. Python in Excel Overview Yesterday (2023-08-22), Python in Excel was announced at Microsoft Tech Community. In the meantime, we have been using a separate library to link Excel and Python, but finally we provide linkage in a basic environment without the need for separate installation. Announcing Python in Excel: Combining the power of Python and...

News roundup on Microsoft 365 Copilot

Microsoft 365 Copilot was announced last Friday (2023-03-17). By integrating ChatGPT into Microsoft 365, it seems that it can significantly improve user productivity. I've been watching ChatGPT since the end of last year. ChatGPT is spreading faster than any software or service ever introduced to the world. ChatGPT 3.5...

Creating a Dark Theme in VBE (VB Editor)

VBE (VB Editor), an editor that codes Excel VBA, does not have a function to set dark mode among the provided functions. The following screen was mentioned in Excel VBA Lecture (5): Excel File Extension, VBE, Font Setting #2.7.4._VBE_Screen_Composition. As you can see in the image above, the VBE default screen is displayed in black text on a white background....

Scheduled to block execution of VBA macros received from the Internet (from 2022-07-27)

I have a new news related to VBA, so I write a brief article. From 2022-07-27, the execution of VBA macro files received from the Internet will be blocked. This is a security measure to prevent someone with malicious intent from distributing malicious code using macros. Only MS 365 Office apps running on Windows. Runs on Mac OS or installs...

en_USEnglish