Data Validation

I have the following macro which transfers values from a sheet ("BM1") and inserts them into another sheet ("Banking")

It then calls another macro and moves back to the original sheet.

I have a potential issue as I have a Data Validation rule set up on the "Banking" sheet to make sure only certain values can be entered, but when the values are inserted via this method the Data Validation is ignored.

How can I ensure the Data Validation is adhered to with VBA?

Please Login or Register  to view this content.

As Data Validation is for manual input only, you can use an advanced filter or any other way respecting the rules …

Thanks for your response, can you advise how I might check via VBA that the value is correct, it refers to a dynamic list:

Formula:

Please Login or Register  to view this content.