Field control

  • Thread starter Thread starter correomaster
  • Start date Start date
C

correomaster

Hello!

I have set up an emailable spreadsheet that acts as a form. This "form"
is sent to myself to consolidate the data. Would it be possible for
this form to stop the macro (and subsequently not being emailed) until
certain "compulsary" fields are filled in by the user?

Thanks in advance.

CorreoMaster
 
Hi correomaster

You can use the Counta function in VBA to test if all cells have a value in the range

Example for A1, A3 and A5

If Application.WorksheetFunction.CountA(Range("A1,A3,A5")) = 3 Then
'mail code here
Else
MsgBox "Sorry"
End If
 

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

Access Automatically Send a notification email once a record is added 0
Dynamic form 3
Email the form 1
Custom New message template 3
Required field on form 0
Outlook Creating an Outlook form 2
Copy compare worksheets 1
Access MS Access VB 0

Back
Top