Thread: how a msg pop up if user enter data in col A but forgot data col B
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
  
Posts: 3,355
Default how a msg pop up if user enter data in col A but forgot data col B
You could use a worksheet.change event to do this, but it would require some
coding. Is that what you want?

"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
Reply With QuoteReply With Quote