Macro for submitting data

[John_Help_Me]

All:

I have a macro button from a command button. The macro just autopopulates data for me into a sheet. How do I validate that data has been entered, meaning how does the macro know?

For example, in the data sheet, the user must enter in Name, Address and Phone number, in cells A1, A2, and A3, respectively. They then click the button and my other sheets gets populated with all three information.

How can I make it so that the user MUST enter all three data points?

Thanks in advance.
John

 

[Andrew Poulsom]

An example:

Sub Test()
    With Worksheets("Sheet1")
        If WorksheetFunction.CountA(Range("A1:A3")) <> 3 Then
            MsgBox "Data missing"
            Exit Sub
        Else
'           Your code
        End If
    End With
End Sub

 

[John_Help_Me]

Thanks. Works like a charm!!!!