Macro To Prompt User To Input Data

    Re: Macro To Prompt User To Input Data


    Assuming A1 should be populated:


    Code
    Sub MakeSure()
If Range("A1").Value = "" Then
        MsgBox "Please enter a value for A1"
End If
End Sub


    I hope this helps.


    Mac

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login