Field control "correomaster" <correomaster[ at ]gmail.com> 23.08.2006 14:04:33 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

Re: Field control "Ron de Bruin" <rondebruin[ at ]kabelfoon.nl> 23.08.2006 16:18:52 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 -- Regards Ron de Bruin http://www.rondebruin.nl "correomaster" <correomaster[ at ]gmail.com> wrote in message news:1156341873.545269.115990[ at ]b28g2000cwb.googlegroups.com... [Quoted Text] > 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 >