Pop up Message box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all

I need a little bit of help as my programming knowledge is shall we say a
little lacking!

On my spreadsheet it became necessary to flag one in every 5 specific deals,
i currently have the spreadsheet set up to count the said specific deals with
this formula, =COUNTIF(J32:J221,"Self Cert") then in the next cell the
following formula that displays a message in this cell
=IF((MOD((B6),4))=0,"Audit Next Case").

However i feel that some people are missing this little message so what i
would like to do it have a pop up box that they have to click ‘ok’ to get rid
of that will appear on every 5th self cert case.

If someone could give me, some code to do this and where to enter said code
i would be most grateful.

Thank you for your time
 
You can look at Data=>Validation. There are options there for popping up
such a window when a cell is selected. You can turn on the macro recorder
while you apply that formatting manually, then turn it off and look at the
recorded code.
 
Back
Top