Monday, September 26, 2016

Troubleshoot:Custom data validation using two criteria

Custom data validation using two criteria

I have a question about the formula to enter in a custom data validation entry.  The data in the cell in which I want to set a validation parameter should be between zero and one (both are valid entries, so equal/greater than zero and equal/less than one)
AND the value in another checkbox cell must be false.  Thus:

Condition 1:   Value of separate cell, say A1, = False
Condition 2:   Value entered in subject cell, >= 0 and <=1

These seems like a simple issue, but I have been unsuccessful in creating the formula in the custom formula window.

Any suggestions?  Thank you.

Keys to the Problem Custom data validation using two criteria

Download SmartPCFixer for Free Now

Thank you so much for clearly documenting your scenario.
I followed your instructions and discovered the flaw.
Here's a change that will make everything work the way you want:

Use this code in the general module:
Sub MyCheckBoxChange()
    With Sheets("Service Policies Description")
        If .Range("ZZ19").Value <> False Then
            Application.EnableEvents = False
            .Range("u19").ClearContents
            Application.EnableEvents = True
        End If
    End With
End Sub

(using Range("ZZ19") is much easier to understand than: Cells(19, 702)...don't you think?)

Does that help?

Ron Coderre
Microsoft MVP - Excel (2006 - 2010)

P.S.
If any post answers your question, please mark it as the Answer
(That way it won't keep showing as an open item.)

In this method we will try to Boot in Safe mode with Networking and see if the error still persists.

  • Search "MSCONFIG" and Open.
  • Click on Boot Tab
  • Tick Safe Boot in Boot Option
  • Select Network.
  • Click Apply and OK.
  • Reboot your System.

Recommended Method to Fix the Problem: Custom data validation using two criteria:

How to Fix Custom data validation using two criteria with SmartPCFixer?

1. Click the button to download Error Fixer . Install it on your system.  Open it, and it will perform a scan for your computer. The errors will be shown in the scan result.

2. After the scan is finished, you can see the errors and problems need to be repaired. Click Fix All.

3. When the Fixing part is finished, your computer has been speeded up and the errors have been removed


Related: How to Update & Download NVidia GeForce 6100/nForce 420 WHQL Certified driver v.178.13,How to Update & Download NVidia GeForce 7600 GS Video Driver v.295.75 Certified,How Can I Update & Download NVidia GeForce 820M Driver v.344.48 WHQL,[Solved] Download NVidia GeForce GTX 560M VGA Driver v.296.17 Certified,Way to Update & Herunterladen NVidia GeForce GT 130M Video Treiber v.295.75 Certified,How to Update & Download SONY SVE14A1X1RH Realtek Ethernet Driver,Where to Download SONY SVS13A2W9ES Bluetooth Driver (Intel) v.2.6 - 2.6.23.40059,Best Way to Update & Download SONY VGN-CR203E Conexant HDAUDIO SoftV92 Data Fax Modem with SmartCP Setup Program v.7.62.0.50 driver,Best Way to Download SONY VGN-FE790G/N Wireless LAN Driver v.10.6.0.29,Method to Update & Download SONY VGN-NR31Z/S Firmware Extension Parser Device v.8.0.2.3,How to Fix Error 0x0000c1f5 SoluciĆ³n?,Error 0x80071a91 Win7 Fix Patch,Error 0x800ccc60 Windows Live Mail [Solved],Error Message 0x800ccc79 Outlook 2000 Fix,What is Error 0xc1ab0001?,[Answered] x64 saplugin dll,How to Fix Problem - Kb943729 Download?,Troubleshooting: Bccode D1 Error,Java Runtime Tech Support,Troubleshooting: ERROR NO SUCH GROUP Error
Read More: Data validation in Excel 2010 and older version,How to Fix Error - D.V.D. burner will not create a D.V.D. from \"Windows Movie Maker\" program?,Definition Update for Windows Defender - KB915597 (Definition 1.97.1491.0)__ [Solved],Fast Solution to Problem: Delete History of shared excel,Troubleshoot:custom formula in data validation Error

No comments:

Post a Comment