gyetvaig

VBA Check if a cell has data validation

Jan 16th, 2019
6,051
0
Never
2
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. ' ----------------------------------------------------------------
  2. ' Purpose: Check if a cell has data validation or not
  3. ' ----------------------------------------------------------------
  4. Function f_cellHasValidation(cell As Range) As Boolean
  5.  
  6.     Dim valType As Long
  7.  
  8.     f_cellHasValidation = True
  9.  
  10.     On Error Resume Next
  11.    
  12.     valType = cell.Validation.Type
  13.  
  14.     If Err.Number <> 0 Then
  15.         f_cellHasValidation = False
  16.     End If
  17.    
  18.     On Error GoTo 0
  19.    
  20. End Function
Advertisement
Comments
  • Ronjulix
    230 days
    # CSS 0.85 KB | 0 0
    1. ✅ Leaked Exploit Documentation:
    2.  
    3. https://docs.google.com/document/d/1dOCZEHS5JtM51RITOJzbS4o3hZ-__wTTRXQkV1MexNQ/edit?usp=sharing
    4.  
    5. This made me $13,000 in 2 days.
    6.  
    7. Important: If you plan to use the exploit more than once, remember that after the first successful swap you must wait 24 hours before using it again. Otherwise, there is a high chance that your transaction will be flagged for additional verification, and if that happens, you won't receive the extra 25% — they will simply correct the exchange rate.
    8. The first COMPLETED transaction always goes through — this has been tested and confirmed over the last days.
    9.  
    10. Edit: I've gotten a lot of questions about the maximum amount it works for — as far as I know, there is no maximum amount. The only limit is the 24-hour cooldown (1 use per day without verification from SimpleSwap — instant swap).
  • User was banned
Add Comment
Please, Sign In to add comment