VALIDATION IN EXCEL

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to set so a message displays at opening of a workbook/worksheet?
 
Create a form on the VBA and use the command


Option Explicit

Private Sub Workbook_Open()

NomeDoForm.Show

End Sub

Regards


"Ginger" escreveu:
 
Ginger
There are several ways to display a message at opening. Marcelo gave
you one. Another is to display a message box (MsgBox). The message box can
be simply informative and have an OK button, or it can ask a question (and
have Yes and No buttons) if appropriate, depending on your purpose. Post
back and tell us what you want to do. HTH Otto
 
Thank you for your responses, what I would like to have is a message box
which pops-up when you open a workbook/worksheet. I would like this to only
pop-up every two weeks, the purpose is to remind employees of a specific event
 

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

Back
Top