View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
Posts: 2,344
Default how a msg pop up if user enter data in col A but forgot data col B


--
Thanks,
Shane Devenshire


"Celline" wrote:

column A column B
123 788

if column A = blank, b=blank
if column A= non blank, b=blank = error
A message shuould appear & remind the user to key in data in B
if column A=blank, b=non blank = not acceptable