info box "y"

Chavira55 · Oct 3, 2002

is there a way to put an information box when a workbook is activated to say " please answer all questions" "press

to proceed" I dont want them to just hit enter when a question pops up (it messes up the sheet) thanks in advance for the help

Andrew Poulsom · Oct 3, 2002

It depends on how you are asking the question, but you can disable the OK button until they answer the question. Like this:

Code:

If TextBox1.Text = "" Then
   CommandButton1.Enabled = False
Else
   CommandButton1.Enabled = True
End If