Business Model Canvas (Excel VBA)

in•sane
3 min readNov 20, 2023

Alexander Osterwalder created a way to display how a business operates with nine building blocks: Key Partners, Key Activities, Value Propositions, Customer Relationships, Customer Segments, Key Resources, Channels
Cost Structure, and Revenue Streams.

If you want to use Microsoft Excel to Create a printable .xslx document, do the following.

If you need to get Excel, it’s available here: https://www.microsoft.com/en-us/microsoft-365/excel

Create a Blank workbook.

Make sure the Developer Tab is visible.

If you can’t find the Developer Tab, follow these steps:

  1. On the File tab, go to Options > Customize Ribbon.
  2. Under Customize the Ribbon and under Main Tabs, select the Developer check box.
  3. Press OK.

Click the [Visual Basic] button on the Developer Tab. It’s in the Code section.

Insert a Module.

Paste the following VBA code and paste it in the Excel Module.

Sub CreateBusinessModelCanvas()
Dim ws As Worksheet
Set…

--

--