Excel Guides

Adding Pop-Up Documentation to a Cell in Excel

Adding pop-up documentation to a cell in Excel is a great way to add extra information for users without taking up valuable space on the worksheet. To add a pop-up note, first select the cell you want to add the note to. Then, click the "Insert" tab on the ribbon and click the "Shapes" button. From the drop-down menu, select the "Rounded Rectangle" shape. Draw the rectangle in the cell next to the cell you want to add the note to. Once the rectangle is drawn, right-click it and select "Edit Text." This will open a text box where you can type your documentation.

In the text box, type the documentation you want to appear in the pop-up note. Once you're finished, click outside of the text box to close it. Now, right-click the rectangle and select "Assign Macro." This will open the Macro dialog box. In the Macro dialog box, click "New." This will create a new macro. In the macro editor, type the following code:

Sub ShowPopup()

Dim strMessage As String
strMessage = Range("A1").Value

MsgBox strMessage, vbOKOnly + vbInformation, "Pop-Up Documentation"

End Sub

This code will display the contents of cell A1 in a pop-up message box when run. You can change "A1" to any cell reference to display different information in the pop-up. Once you've entered the code, click "Save" and close the macro editor.

Now, go back to Excel and test your macro. Select the cell with your documentation and press Alt+F8 to open the Macro dialog box. Select your macro from the list and click "Run." A message box should appear with your documentation. If it looks good, close the message box and press Alt+F8 again to close the Macro dialog box.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.