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.

--
Regards,
Tom Ogilvy


"tuk16664" wrote:

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