Data Validation & Cascading

[Krupa]

Hey everybody,

Okay this is my problem. I have one data validation box that is dependent on another. Let's say Cell A and Cell B. Now when the value of cell A is changed, the list cell B changes as well, but value of cell B is from the old list and not apart of the new list. I would like for the value of cell B to be cleared out when its list changes. Any ideas?

Krupa

 

[Fryer Tuck]

Not sure that I understand what you are after, but it sounds like you need an If/Then statement in the spreadsheet object code, along the lines of:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If target.address = A Then
clear b, or put new value into b, or whatever it is you are trying to do
End if
End Sub

F.T.

 

[Krupa]

Well i was trying to avoid the worksheet_Change route. You see i am doing import and export from a database and everytime i write something to the cell it goes to this piece of code. It increase my import speed too much for this to be an option. Unless there is a way to temporarily shut off the worksheet_change method.