Hi

If in cell C6 i have the message 'audit this case' that appears on every 5th
case and is blank any other time, how can i get this cell to generate a pop
up messgae box to give the same message of audit this case when the same
senario is reached?

is it a "message box" from a macro, or one that comes from selecting
that specific cell? if it's the latter, it's a VALIDATION messge.

on any cell, in the toolbar select DATA, VALIDATION
then choose the Input Message tab & write what you want.
you can copy this, if you wish, to other cells - just copy that cell
and paste formatting in the other cells.
:)
susan




On Aug 9, 10:12 am, tuk16664
wrote:
Hi

If in cell C6 i have the message 'audit this case' that appears on every 5th
case and is blank any other time, how can i get this cell to generate a pop
up messgae box to give the same message of audit this case when the same
senario is reached?