View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_5_] Bob Phillips[_5_] is offline
external usenet poster
 
Posts: 620
Default Setting a required cell

In the code behind the button, check that the cell is not empty

If IsEmpty(Range("C1).Value) Then
'error
Else
'send it
End If

--

HTH

Bob Phillips

"wjd01" wrote in message
...
Hello,
I have a workbook that contains three sheets. One of the
sheets is setup as a form that the user will fill out, and
then click a button to send via outlook enclosure. Is it
possible to set a cell on a sheet as "required" (needs
entry) so if the cell is blank, the workbook can not be
mailed?

Thanks.