Macro to check if data has been entered

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

Guest

Greetings,
I have a macro button that I use to help people go to the routing dialog
area. I would like to put some code in to check to ensure that the user has
answered all of the questions. If they left something blank or unanswered, I
would like a message box to come up and say something, then end. It will not
let them go to the Routing area until they answer all questions.

Please help. Thank you in advance.
Mike
 
Something like

If Worksheetfunction.CountA(Range("A1:A10") < 10 Then
Msgbox "Not every question answered"
Else
'goto the routing area
End If

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

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

How to write a Clearcontents command in a macro 4
Verifying if new data has been added to excel file ? 4
Macro to add data once a Pivot Table has been refreshed 1
Check if data has already been formatted. 2
Skip Run macro if module has been deleted 1
Ensuring Combobox has Value entered if another ComboBox has aspecific value 3
Need Macro... 8
Storing VBA Code In a Cell to Use real Time 2

Back
Top