dialog box with text.

  • Thread starter Thread starter Leo Rod
  • Start date Start date
L

Leo Rod

Hi All !

I would like to have a dialog box with a reminder everytime I open an
Spreadsheet.
Please let me know if anybody knows the VB for this, I'm clueless on that
lenguage.

Thanks in advance and greetings,

Leo.
 
Place this code in Thisworkbook module.

Private Sub Workbook_Open()
MsgBox "Have you brushed your teeth today?"
End Sub

To open Thisworkbook module, right-click on the Excel Icon left of "File" on the
menu bar.

Select "View Code" and copy/paste the above into the blank module.

Save and close the workbook.

When you re-open the message should appear.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format Cells Dialog Box Missing 2
Profit and Loss different sections "Excel P&L template" 3
Create a dialog box 3
DROP DOWN MENU "source" 5
Dialog box with worksheet information 3
Center text in dialog box 1
VBA Dialog Box -- 6
Where is the "word options" dialog box in draft view? 3

Back
Top