Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Force required entry in cell before leaving that cell | Excel Worksheet Functions | |||
Required information in a cell | New Users to Excel | |||
How to make a cell required if another cell has text in it | New Users to Excel | |||
Cell function required | Excel Worksheet Functions | |||
can you make a cell value required? | Excel Discussion (Misc queries) |