Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
preventing data entry if one cell's value smaller then zero
Hi everyone;
On my worksheet, users can enter data on E6:J185 range. and C3 cell is counting down from 4.500 the total entered amount. What I would like to do is, while users are entering data, if C3's value is getting smaller than zero, code should warn them and prevent further data entry. Here is my unsuccesful code; Dim OldValue As Variant Private Sub Worksheet_Change(ByVal Target As Range) If (c3) < 0 Then On Error GoTo Whoops Application.EnableEvents = False MsgBox "You Dont Have Enough Points!" Target.Value = OldValue End If Whoops: Application.EnableEvents = True End Sub Private Sub Worksheet_SelectionChange(ByVal Target As Range) If (c3) < 0 Then OldValue = Target.Value End Sub Thanks a lot in advance for your time and help. Regards. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Preventing double entry formula | Excel Worksheet Functions | |||
Data Entry Online, Data Format, Data Conversion and Data EntryServices through Data Entry Outsourcing | Excel Discussion (Misc queries) | |||
"Hot spot" in a spreadsheet that will duplicate the cell's entry to another cell, or to activate a macro | Excel Programming | |||
Preventing manual entry in dropdown list ... possible? | Excel Discussion (Misc queries) | |||
Saving AutoFiltered Data off as a smaller file? | Excel Programming |