F Frank Kabel Nov 30, 2004 #2 Hi this would require vBA. e.g. checking the Beforeclose event -- Regards Frank Kabel Frankfurt, Germany Lisa said: I need to set up a mandatory field in an Excel Template, can anyone Click to expand... help?
Hi this would require vBA. e.g. checking the Beforeclose event -- Regards Frank Kabel Frankfurt, Germany Lisa said: I need to set up a mandatory field in an Excel Template, can anyone Click to expand... help?
D Dave Peterson Nov 30, 2004 #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)
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)
