Excel Writes Poetry

In Hobby

Why: I wanted to experiment with text parsing in Excel, and loops in VBA.

How it works:

  1. Poetry gets pasted into a hidden sheet, one line per cell
  2. A macro parses each verse (row) into one word per column
  3. The number of words (columns) per verse (row) is calculated
  4. A second macro reads each line one word at a time and updates the displayed line to include the next word. A 0.1 second delay gives the visual effect of composing poetry.

I want to try: download it here

Excel Writes Poetry

This Excel spreadsheet allows you to paste any quotation in a hidden sheet, and the spreadsheet can then write out the quotation one word at a time on the dashboard – appearing as if it could write poetry.

ClientAmusementMy RoleI made the spreadsheet and VBA code, with help from StackOverflow. Shakespeare wrote the poetry. Year2017StatusCompletedCategoryHobby