How to create a popup window in Excel 2010
Posted By Quikstarts July 26, 2010 10:27 am

This guide is part of the Microsoft Excel 2010 series

Guides in this series:

1. How to auto fit column width in excel 2010
2. How to create a pie chart in Excel 2010
3. How to create a popup window in Excel 2010
4. How to insert a row into an excel 2010 spreadsheet
5. How to show the developer tab in excel 2010
6. How to use Excel 2010
7. Search for a specific value in cells in Excel 2010


Make: excel

Model / Product: Excel

Version: 2010

Objective / Info: Create a pop up window with a custom message when a workbook is opened in Excel 2010.

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
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.

7
To test the pop-up. Click either the green triangle OR click the "Run" button on the menu, then click "Run Sub/UserForm"
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 owrkbook or close all of the open excel boxes. When this workbook is reopened going forward, you should see the pop up.
Share |
Product Feedback
What do you dislike about this product
What feature do you want to see added to this product

Other guides:

1. Viewing Google mobile search history on an Android
2. Using the Hard Drive Restore Tool
3. Sync the G1 phone with outlook

Tag : spreadsheet

Create your own Guide

Ask a question or provide an answer

Posted Q&A(0)


Name
Email
URL
Comment
 
 
 
 

Categories

  • Mobile Phone
  • Software
  • Internet
  • Programming
  • General
  • Travel
  • Home and Garden
  • ISP


Tags

windows 7   g1 phone   PowerPoint   ftp   Google calendar sync   homepage   clear cache   ie 7   pdf   shapes   animate   image search   map   resolution   windows xp   Internet   computer   screenshot   word   chrome   encryption   temp files   toolbar   temp files   FireFox   php & mysql   google define   portable air conditoner   Smartrip Card   image   analytics   real time search   google docs   gmail   archive   Paypal   pie chart   GOOG 411   publisher   boot cd   decrypt   email   skype setup   spreadsheet   picassaweb   clear history   outlook setup   hard drive   search history   zip   auto-save   ip address   comcast   dvr   caller id   Live movie maker   Mobify   IE 8   google voice   app inventor