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