VBA not working with existing cell validation

[Meghanao]

I have a series of dropdown boxes where, if cell B2 has a value, this value will filter through and populate the dropdown cells via VBA. This works, however, if invalid data is entered in B2, the dropdown cells still allow the bad data, where if i enter the same info directly in Excel, it gives me an invalid data error. Why the difference?

In the code below, B2 is named "Provide_SKU". B2 is split into the appropriate parts in row 3, then row 8 (the dropdowns) is set equal to row 3.

Please Login or Register  to view this content.

[Richard Buttrey]

Hi and welcome to the forum.

I'm not sure I understand the requirement. Would you upload the workbook and tell us what actions you want to take and what results you would expect.

[Meghanao]

Hi, Thanks for the welcome.ABH_Config-Forum.xlsm

I'd like to be able to paste a SKU in B2 (there are test "valid" skus available below) and have it fill the dropdowns with valid data. It is filling the dropdowns, but if I enter invalid data in B2, it does not alert me. If the user enters invalid data, give an alert or somehow show that this is invalid. If I type the data wrong directly in the cell, or use a formula in cell B8 to say =B3, it does not allow it. But the VBA is accepting bad data if entered in B2. Make sense?

[jaslake]

Hi Meghanao

Add a Dynamic Named Range called Test_SKUS then add these Lines of Code to your Sheet Change Code

Please Login or Register  to view this content.