software

I am sending a excel spreadsheet out to my end users to collect business
related data.

I'd like to make a cell value required, is this possible?

If answer to question asked in column F is quot;YESquot;, make column E a
required. Can this be done using excel?--
nishapurohit
------------------------------------------------------------------------
nishapurohit's Profile: www.excelforum.com/member.php...oamp;userid=30983
View this thread: www.excelforum.com/showthread...hreadid=506582I'd use column G:

=if(f2lt;gt;quot;yesquot;,quot;quot;,quot;Please answer the question in column E!quot;)

Format it in nice big bold red letters.

nishapurohit wrote:
gt;
gt; I am sending a excel spreadsheet out to my end users to collect business
gt; related data.
gt;
gt; I'd like to make a cell value required, is this possible?
gt;
gt; If answer to question asked in column F is quot;YESquot;, make column E a
gt; required. Can this be done using excel?
gt;
gt; --
gt; nishapurohit
gt; ------------------------------------------------------------------------
gt; nishapurohit's Profile: www.excelforum.com/member.php...oamp;userid=30983
gt; View this thread: www.excelforum.com/showthread...hreadid=506582

--

Dave Peterson


Once you've got your answer you can write a macro that will run when the
workbook is saved. Maybe not the most succinct method, but the only one
I know:

In 'ThisWorkbook' write:

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)
If Cells(y1,6).value = quot;yesquot; then
If Cells(y2,5).value = quot;quot; then
MsgBox(quot;Please enter value in cell y2,5)
Cancel = True
End If
End If
End Sub

where y1 and y2 are the relevant rows.--
PipTT
------------------------------------------------------------------------
PipTT's Profile: www.excelforum.com/member.php...oamp;userid=30989
View this thread: www.excelforum.com/showthread...hreadid=506582