Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Cell Required before Closing
I am trying to require that the cells in column G thru J be filled out if column C contains a certain value. I have been successful at making cell G5 be required if C5 has a value but I can not expand on this. For example:
If C5 = "Proposal" then G5, H5, I5, J5 are required. If C6 = "Proposal" then G6, H6, I6, J6 are required. etc all the way to C2006. This is what I have so far: If Worksheets("2012").Range("C5").Value = "Proposal" Then If Worksheets("2012").Range("G5").Value < "" Then MsgBox "You must fill in Proposal Data." Cancel = True End If Any thoughts? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Required before Closing
Jenn T wrote:
I am trying to require that the cells in column G thru J be filled out if column C contains a certain value. I have been successful at making cell G5 be required if C5 has a value but I can not expand on this. For example: If C5 = "Proposal" then G5, H5, I5, J5 are required. If C6 = "Proposal" then G6, H6, I6, J6 are required. etc all the way to C2006. This is what I have so far: If Worksheets("2012").Range("C5").Value = "Proposal" Then If Worksheets("2012").Range("G5").Value < "" Then MsgBox "You must fill in Proposal Data." Cancel = True End If Any thoughts? Try this: With Worksheets("2012") For ro = 5 To 6 If .Cells(ro, 3).Value = "Proposal" Then For co = 7 To 10 If .Cells(ro, co).Value = "" Then .Cells(ro, co).Activate MsgBox "You must fill in Proposal Data." Cancel = True Exit Sub End If Next co End If Next ro End With -- When you grow up, your heart dies. |
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 | |||
How do I work on data starting to a cell a cell with a required va | Excel Programming | |||
Cell function required | Excel Worksheet Functions | |||
Setting a required cell | Excel Programming |