How to create a popup window in excel 2013





Posted By nikki
List ViewGrid View

This guide is part of the Microsoft Excel 2013 series



Make: Microsoft

Model / Product: Excel

Version: 2013

Objective / Info: Learn to create a popup window in excel 2013.


1
Start Excel by clicking the icon on the desktop or start menu.

2
Open a new or existing worksheet.

3
Click the "Developer" tab on the menu.
4
Click the "Visual Basic" button.
5
We will select the entire workbook for this example. This means the message should be shown whenever the workbook is opened.
6
Double click on "ThisWorkbbook" to open the Visual Basic Editor.
7
In the Visual Basic Editor, paste the following code into the box to the right: Private Sub Workbook_Open() MsgBox "This is your personal message" End Sub
  Note : Replace this portion "This is your personal message" with your own message.

8
You should now see what your pop-up box will look like.
9
You should be returned to the visual basic editor screen. Click the save button.
10
This is important. Click the "No" button.
11
Type the name you want to give your file in the "File Name" box. Then click the drop down box labeled "Save as Type"
12
Make sure you select the Save as Type of "Excel Macro-Enabled workbook (*.xlsm)" and click the "Save" button.
13
You can now continue to edit the workbook or close all of the open excel boxes. When this workbook is reopened going forward, you should see the pop up.
  Note : You may receive a warning message asking you to enable marcos. Accept it to see the popup.

14
This task should be complete. Review the steps if you had any issues and try again. Submit questions or request for more guides in the questions section below.

|






comments powered by Disqus

Tag : Popup Window

Ask a question or provide an answer

Posted Q&A(0)


Name
Email
URL
Comment