Warning screen

  • Thread starter Thread starter nona
  • Start date Start date
N

nona

Hello everybody, I've tried the flashing formulas and they worked but
the problem is that they make the sheet to slow to work with:(.

Now I want to try to make a warning pop up screen which warns when
something is filled in, in one or more of the following cells: B17,
B33, B42 and B54, after pushing a finish button.

(The cells mentioned above already automaticly change into an empty
cell when a related cell is filled in and normally warn that something
is not filled in)

How can I do this? :confused: :confused: Thank in advance for the
help!!!
 
Maybe this idea will help.
right click sheet tab>view code>insert this>SAVE
Now when there is a change anywhere on the sheet this will fire.
Or, if you finish button is tied to a macro, just add the 3 lines inside
this.

Private Sub Worksheet_Change(ByVal Target As Range)
If Application.CountA(Range("b17,b33,b43,b54")) > 0 Then
MsgBox "popped up"
End If
End Sub
 
Back
Top