Your first VBA macro: from setup to execution

From preparation to Run, try it yourselfFinal practice

XBook1.xlsm - Excel

FileHomeInsertPage LayoutFormulasDataReviewViewHelp

📋PasteBBold▦Borders≡arrangement%numerical value▦tableΣAutoSum

A1fx

	A	B	C	D	E
1
2
3
4
5
6
7
8
9
10

Sheet1⊕Ready

Ctrl

KeyCat

All three were like magic... Can I make it too?

NextEnter ↵

This is a simple exercise using a real Excel (Microsoft 365/Windows version) screen. In the Mac version, display the developer tab by selecting "Preferences" → "Ribbon and Toolbar" from the "Excel" menu. The actual preparation steps in Excel and frequently used codes areHow to get started with VBA and a list of frequently used codesIt is summarized in

This is an exercise that reproduces the Windows version of Excel. The keys on the ribbon differ depending on the display language, so you can also use the buttons on the screen. On Mac, open VBE with Option+F11. Depending on your keyboard settings, you may also need the Fn key. The VBA syntax and the function name passed to .Formula remain in English.