valid

We have an issue where end users have to update a spreadsheet with data, which then feeds another application. However, because end users are not following the format, or entering bogus numbers in a field, our data gets corrupted on the end. I would like to create a VB script that checks...

Hello! First time posting, so appreciate your help. I need to restrict input in a cell to EITHER: 1) A Valid Date 2) A short list of text inputs ("Cancelled", "Withdrawn", etc) Ideas? Thanks for your help! Robb

Hi all, I've created a spreadsheet for our company's credit card expense reports that has dependent data lists for showing valid account numbers based on the home department of the employee for whom the report is being completed. The workbook worked great until I revised it this year adding a...

2 questions about combo boxes. I have one that references a column with 9 entries. Depending on the value in a cell some of those entries may be blanked out because they are invalid. A blank cell could of course be erroneously selected and need correction. Is there a better way to handle...

I have a column of data with numeric values. Anything greater than 0 is valid, but how can I easily clear the contents of the cells with '0' as a value? I have the same problem with a column of data with text. Anything with a value greater than "" is valid, but many cells have a value of ""...

Hi, I am not sure if I am giving you enough information on what I am looking for. I have an Excel Template where users can just check if a number is valid after clicking to a button. Basically, there's a cell where you type a number, like phone number and by clicking on the button Check, it...