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?

Please or register to post comments
If spammers comment on your content, only you can see and manage such comments Delete all

Vba excel validating data in cells introduction

Vba excel validating data in cells

Recent posts

27-Sep-2018 19:24
28-Sep-2018 02:05
28-Sep-2018 11:44
28-Sep-2018 20:23