Vba excel validating data in cells Dirty bi men chat
There will be about 1000 rows in this spreadsheet and I have attempted this using the data validation but it would involve me going in row by row.
In the following example, the user has typed abc , which is not an acceptable value in that cell.
If you see a data validation alert when you try to enter or change data in a cell, and you're not clear about what you can enter, contact the owner of the workbook.
Normally it is possible to apply data validation in excel through vba but i am having a specific problem I am using the indirect method for applying validation,normally when i dont use vba i get a warning by excel that "source currently evaluates to an error,do u want to continue?
If I enter 35 data validation isn't triggered and the VBA "logic" doesn't loop (at any time) If I enter 950 data validation (in Excel not VBA) is triggered and retry is selected - enter 35 and the VBA "logic" loops twice I'm using Worksheet_Change(By Val Target As Range) I'm using Application.
Enable Events = False with calling of several sub-routines. Enable Events to True only once at the end of the Worksheet_Change sub() Is there another "setting" that needs to be controlled - in addition to Enable Event?