Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do you set up a mandatory field in Excel?
I need to set up a mandatory field in an Excel Template, can anyone help?
|
#2
|
|||
|
|||
Hi
this would require vBA. e.g. checking the Beforeclose event -- Regards Frank Kabel Frankfurt, Germany "Lisa" schrieb im Newsbeitrag ... I need to set up a mandatory field in an Excel Template, can anyone help? |
#3
|
|||
|
|||
Maybe you could have an adjacent cell with a formula like:
=if(a1<"","","Please Fill In A1!") format in nice big red letters. And if you have any important calculations, you could add a check to make sure that the cell is completed before you show the results: =if(a1="","Not until you fill in A1",yourcalculationhere) Lisa wrote: I need to set up a mandatory field in an Excel Template, can anyone help? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel converts Mapped drive to UNC - How to stop? | Links and Linking in Excel | |||
Creating GIFs in Excel 2003 for use in Dreamweaver | Charts and Charting in Excel | |||
Excel 97 chart opened in Excel 2003 - Source Data problem | Charts and Charting in Excel | |||
Staring Excel Problem | Excel Discussion (Misc queries) | |||
No Smart Tag help: just a blank "MS Excel Help" window - Excel 2003 | Excel Discussion (Misc queries) |