View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kobus Kobus is offline
external usenet poster
 
Posts: 22
Default Preventing cell from being empty

Hi all
I have a few sheets in my workbook. On each sheet are a few cells that are
essential for calculations. I have managed to specify the range that the
values may have in these cells. But I want to check that the cell is not
empty when the cell loses focus. Is there a way of doing this with VBA (or
with the Excel functionality itself)?
Thanks