I am using Data Validation and I don't want the user to go past a cell without putting in an entry. When I leave the box (ignore blank) unchecked it doesn't do anything after I have protected the document.
Sorry to resurrect such an old thread but it is so close to what i need i was hoping that somebody may be able to use the above and help me get to what i need.
So I have a similar issue but i will try to explain my scenario a little first:
I have a table that users record the names of people who have performed each of the required 5 tasks per project.
So each time they perform a project they must add a new line to the table detailing the project number and names under each of the 5 headings.
I want to stop them from leaving any names left out so once a project number is entered i want it to force them to enter the names. (once we get this far i will then go onto the rules for not allowing the same name under certain tasks lol)
All i have done so far is data validation to provide a drop down list of names for each task, and the conditional formatting on two columns at the end to display red or green for the checks on the duplicate names under certain tasks.
I hope this makes sense, and hope somebody can help me achieve what im after here Thanks in advance
Right click the worksheet Tab,Choose View Code and Paste the Following Code:
Code:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address > [c4].Address Then
If IsEmpty([c4]) Then
MsgBox "Cell C4 Must Have A Value." _
, vbCritical, "There Is A Problem!"
[c4].Select
End If
End If
End Sub
Curious if anyone found an answer as to how to apply this to multiple cells. I get an error "Compile error: Ambiguous name detected: Worksheet_SelectionChange" when I try to copy, paste and change the cell reference.
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.