View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ddwebb ddwebb is offline
external usenet poster
 
Posts: 1
Default Cell not null value?

I am new to this VB macro stuff, so I am looking for a little help.

I have a worksheet that I want the user to NOT be able to leave certai
fields blank. How do I create a macro that will do that and issue
message box telling them that they must enter a value in this cell?
I will have several cells that I want to check.
Can this be done before they save and close the spreadsheet?
Thanks
d

--
Message posted from http://www.ExcelForum.com