View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tuk16664 tuk16664 is offline
external usenet poster
 
Posts: 8
Default Pop up Message box

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