Excel formula - request assistance

  • Thread starter Thread starter srain001
  • Start date Start date
S

srain001

Hi,

I'm looking for a way to make a "pop-up" appear when a particular cell is
left blank.

For example,

If cell 1 in Column A is filled with the term "Collateral" (picked from
dropdown), then cell 1 in Column D must be filled. I'm looking for a formula
or macro to make this mandatory so that people filling out the spreadsheet
cannot ignore column D when that specific entry is used in column A.

Any help would b great. Tnx!
srain
 
You can't make a Pop-up appear with just a formula........you need VBA for
that. What you could do is just do Conditional Formatting on the cell to
turn it Bright RED if the first cell contains "collateral" and this one is
not yet populated.

Vaya con Dios,
Chuck, CABGx3
 
Here is your pop-up.

Enforcement would take much more, like locking all cells except D1 so user has
to enter something in D1 before going any further.

Option Compare Text
Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo stoppit
Application.EnableEvents = False
If Me.Range("A1").Value = "Collateral" Then
MsgBox "Please be advised that D1 must be filled."
End If
stoppit:
Application.EnableEvents = True
End Sub


Gord Dibben MS Excel MVP
 
Back
Top