• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 36
  • Last Modified:

Dialog box when Excel opens

Folks,
I am have started a workbook that still has some work to do. I will be sending this to show some of my skills. What I need is a dialog box that notifies the user what part of the workbook is still a work-in-progress. How is that done?
0
Frank Freese
Asked:
Frank Freese
  • 3
  • 2
1 Solution
 
Martin LissOlder than dirtCommented:
One way is with a simple Msgbox. In Workbook_Open:

Private Sub Workbook_Open()
MsgBox "...is not complete yet", vbInformation, "Project Status"
End Sub

Open in new window

0
 
Martin LissOlder than dirtCommented:
Or try this workbook. Every time the workbook is opened the 'Status' sheet will show up. It will disappear when you select another sheet.
29099562.xlsm
0
 
Frank FreeseAuthor Commented:
Thanks Martin - worked as expected.
0
 
Martin LissOlder than dirtCommented:
I corrected the typo:) and you’re welcome and I’m glad I was able to help.

If you expand the “Full Biography” section of my profile you’ll find links to some articles I’ve written that may interest you.

Marty - Microsoft MVP 2009 to 2017
              Experts Exchange Most Valuable Expert (MVE) 2015, 2017
              Experts Exchange Top Expert Visual Basic Classic 2012 to 2017
              Experts Exchange Top Expert VBA (current)
0
 
Frank FreeseAuthor Commented:
Well there older than dirt,
Thanks for the correction and links. Have a safe summer
0

Join & Write a Comment

Featured Post

Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now