View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jock Jock is offline
external usenet poster
 
Posts: 440
Default Message box warning of missing data

Hi,
When a user inputs data (numbers) into cells in column D, they should
include a three digit prefix before the numbers. I would like a message box
to pop up if they fail to do this and delete what they have put in the cell
thus forcing them to try again. For example 09/123 would be rejected but
SUM09/123 would be ok.

Thanks in advance.
--
Traa Dy Liooar

Jock