|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 11th 12, 07:15 PM
|
|||
|
|||
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? 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Force required entry in cell before leaving that cell | Retired Bill | Excel Worksheet Functions | 8 | March 17th 09 10:57 PM |
| How to make a cell required if another cell has text in it | Jonine | New Users to Excel | 3 | June 19th 07 06:05 PM |
| How do I work on data starting to a cell a cell with a required va | Tom London | Excel Programming | 6 | October 22nd 06 04:46 PM |
| Cell function required | mickbarry | Excel Worksheet Functions | 6 | February 7th 06 11:34 PM |
| Setting a required cell | igor | Excel Programming | 0 | August 20th 03 05:40 PM |
Threaded Mode