Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
can you make a cell value required?
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 "YES", make column E a required. Can this be done using excel? -- nishapurohit ------------------------------------------------------------------------ nishapurohit's Profile: http://www.excelforum.com/member.php...o&userid=30983 View this thread: http://www.excelforum.com/showthread...hreadid=506582 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
can you make a cell value required?
I'd use column G:
=if(f2<"yes","","Please answer the question in column E!") Format it in nice big bold red letters. nishapurohit wrote: 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 "YES", make column E a required. Can this be done using excel? -- nishapurohit ------------------------------------------------------------------------ nishapurohit's Profile: http://www.excelforum.com/member.php...o&userid=30983 View this thread: http://www.excelforum.com/showthread...hreadid=506582 -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
can you make a cell value required?
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 = "yes" then If Cells(y2,5).value = "" then MsgBox("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: http://www.excelforum.com/member.php...o&userid=30989 View this thread: http://www.excelforum.com/showthread...hreadid=506582 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make a cell required to edit in Excell? | Excel Discussion (Misc queries) | |||
How to take a cell that has 3 values and make 2 more new lines | Excel Worksheet Functions | |||
Can I make a formula in Excel to display result in same cell? | Excel Worksheet Functions | |||
How to make a flexible cell reference? | Excel Discussion (Misc queries) | |||
make a cell empty based on condition | Charts and Charting in Excel |