Data Validation & Cascading

Krupa

New Member
Joined
Oct 7, 2002
Messages
8
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
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
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.
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,253
Members
448,556
Latest member
peterhess2002

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top