Validating a cell value excel macro
Each list has a blank cell at the top of the alphabetized list.
The validated lists on worksheet 1 are not crossing merged cells.
The data Validation lists is on worksheet2 (same workbook).
The lists are validated on worksheet 1 using Names (= "listname").
I already have conditional formatting in the spreadsheet, and apparently bright red cell coloring isn't a good enough indicator of "you did something wrong" for the individuals filling out the spreadsheet.
If that's your reasoning, why not lock the dollar cells and only have them unlock when an invoice is entered? And if the invoice number is deleted, it clears the dollars?
If you want to refer to ranges on multiple sheets, you must refer to each sheet separately.
Remember, the shortcut to open your Project Explorer window from your VBA editor is Ctrl-R.object is probably the most frequently used object in Excel VBA—after all, you are manipulating data on a sheet.Although a range can refer to any grouping of cells on a sheet, it can refer to only one sheet at a time.It worked when I closed and re-opened on different days.Instead of using Data Validation, you can use VBA to allow only numbers in a cell or a range in Excel.