Anyone know how to use a UserForm (made in the Visual Basic editor that is is
accessible via Excel's ToolsMacros menu) to display an error message when a
specific cell in a spreadsheet is below a certain value?

I have made the UserForm, but cannot figure out how to link the form to the
cell required. It is being used to alert the end user that their budget is
below $1000; once cell <1000 the form is meant to display.

This is the VB Code I have used:

Private Sub CommandButton1_Click()
End
End Sub

Private Sub UserForm_Click()
Hide UserForm1 = True
If Science!J1000 < 1000 Then
Show UserForm1 = True
Else
End Sub



Please note that I am an amateur user of Excel; please use plain language as
much as possible. :-)

Thanks