FAQ Database Discussion Community


Target.Validation.Type results in “Application-defined or object-defined” error

excel,excel-vba,excel-2013,data-validation
I am trying to determine if a cell has data validation using this statement: If Target.Validation.Type = 3 Then However, I get an error in VBA: application-defined or object-defined error I tried using On error Resume Next and On error Goto 0 but it doesn't help. How do I check...

Modern UI for WPF - ModernDialog: Allow to click Ok only on some conditions

c#,wpf,data-validation,modern-ui
I started a new small project, using ModernUI for WPF. I've to display a Dialog with only two textbox and two button(ok/cancel). The two textbox have some validation(one is a name that should be >0, the other should be an email). Currently I've the following: var userEditionForm = new UserEditionForm(oneUserConfigurationViewModel);...

How can I get data from a Table [closed]

excel,excel-2013,data-validation
Can someone assist me on how can I get data from a table in Excel 2013? I have a table named Personal: and I want to have a control in a cell like this: (I do not know how to add this control in a cell) So I can select...

Data Validation and Scanners in Java

java,java.util.scanner,data-validation
I have a question regarding data validation and scanners.The following piece of code checks userinput.Anything other than an integer is not allowed and the user is asked to re-enter a value.My question is that the code works only if the scanner is declared within the while loop.The program executes infinitely...

How to implement data validation in model of MVVM?

wpf,validation,mvvm,data-validation
I have an MVVM application which requires data validation. I would like to keep the validation in the model, so the model can be easily reused with other view models without having to duplicate the validation code. Most examples of data validation with WPF either have the validation done in...

Data Validation Macro, custom specified range

excel-vba,data-validation
I am writing a code in excel (VBA) that involves creating a Data Validation list from a range of cells in the same sheet. However this range changes by size and by content. Part of the code I am using pertained to data validation is found herein: With Selection.Validation .Delete...

Data validation arrow does not show automatically

excel,data-validation
The arrow box next to all data validation fields in my xlsm file does not show automatically when clicking in the validation cell. It shows up quickly and disappears immediately. When clicking where the arrow box is supposed to be, the data validation options show up as usually and now...

Excel - Data Validation list from filtered table

excel,data-validation
I am looking for a way to make a data validation list pull from a filtered table. Ex. I have a sheet called customers with a table named CustomerList column A=Customer B=Address C=City D=State On another sheet named Quote I have cell C13 for customer name which has a data...

Data Validation Batch Edit

excel,data-validation
I am trying to create a vocabulary quiz in excel, where a correct answer is the only possible input into a cell. So far, I use data validation to ensure that outcome, but cannot figure out a way to batch edit data validation. I want every blank cell's validation to...

Excel dynamic 'Data Validation' list

excel,excel-formula,data-validation
I am using an excel sheet to aid in configuring large xml files. I have the following Where of the 24 different Type options, they share a large amount of common fields to configure (The yellow cells, of which there are 15 columns, followed by 36 more columns that mostly...

Google Sheets - Conditional Formatting based on validation errors

google-spreadsheet,conditional-formatting,data-validation
Is it possible to set the conditional formatting of a cell based on whether or not the cell has a validation error? I have a drop down box and old data in the sheet that doesn't match up to the drop down box list needs to be added to my...

Iterate through an Excel dropdown/validation list

vba,drop-down-menu,data-validation
I have a cell with a validation list that changes depending on other settings. Is it possible to iterate through that cell in code? Is it also possible to set that cell to the nth item in the list? Example: The drop down for E2 depends on what was selected...

How to add Data validation to entire column of an excel sheet using apache poi in java?

java,excel,apache-poi,data-validation
I have a requirement Where I need to add data validation to an entire column rather than a specific cell. I went through the documentation of Apache poi and found the example below HSSFWorkbook workbook = new HSSFWorkbook(); HSSFSheet sheet = workbook.createSheet("Data Validation"); CellRangeAddressList addressList = new CellRangeAddressList(0, 0, 0,...