In my previous post, I showed you how to create a clickable button in Excel.That button displayed a simple message box. Now, I want to show you how to use the button to kick off a PowerShell script.

On the Developer tab, click the Visual Basic button in the Code group. A Microsoft Visual Basic for Application window will open. Click the Insert tab and select Module in the menu. A new model is ...

Clicking the button passes the number 3 to a PowerShell script. Now obviously there are much easier ways to add two to a number using nothing but Excel (no PowerShell). But that isn't the point.