View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre
 
Posts: n/a
Default if the cell value exceeds the limit to have a dialog box appear

Check Data Validation:

Select the cells
DataData Validation
Allow: (check out the number options: whole number, decimal, etc)

Does that help?

***********
Regards,
Ron


"Dschro" wrote:

Is there a way that, if the cell value exceeds a certain limit, a dialog box
would appear?

Thanks for any assistance.

Dave