Don't want cells left blank when using Data validation

trucker

New Member
Joined
Jan 19, 2003
Messages
37
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.

Help
 
Hi guys,

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
 
Upvote 0

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
Hi Trucker,

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


Hope this helps.

Hi Mr. Jaffar may i enter into this discussion? for multiple column from C4:C100 how can you do that? thanks

renato
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,224,827
Messages
6,181,197
Members
453,021
Latest member
pingpong7117

We've detected that you are using an adblocker.

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.
Go back
Back
Top