This guide is part of the Microsoft Excel 2013 series
1.
Add a print button to the tool bar in excel 2013
2. How to add a background image in excel 2013
3. How to add a button to the tool bar in excel 2013
4. How to add a column to a spreadsheet in excel 2013
5. How to auto fit column width in excel 2013
6. How to convert a column into a row in excel 2013
7. How to create a drop down menu in excel 2013
8. How to create a pie chart in excel 2013
9. How to create a pivot table in excel 2013
10. How to create a popup window in excel 2013
2. How to add a background image in excel 2013
3. How to add a button to the tool bar in excel 2013
4. How to add a column to a spreadsheet in excel 2013
5. How to auto fit column width in excel 2013
6. How to convert a column into a row in excel 2013
7. How to create a drop down menu in excel 2013
8. How to create a pie chart in excel 2013
9. How to create a pivot table in excel 2013
10. How to create a popup window in excel 2013
Make: Microsoft
Model / Product: Excel
Version: 2013
Objective / Info: Learn to create a popup window in excel 2013.
Model / Product: Excel
Version: 2013
Objective / Info: Learn to create a popup window in excel 2013.
2
Open a new or existing worksheet.5
We will select the entire workbook for this example. This means the message should be shown whenever the workbook is opened.
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.
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