Setting a required cell
In the button click event, you can check if the required field is
empty. If it is, you can put up a message, redirect focus to the
field, and then exit the sub.
Kin
On Wed, 20 Aug 2003 08:50:03 -0700, "wjd01" wrotE:
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.
|