Restrict values in 1 column

[kathleenfarber]

Hi,

I am trying to restrict values in column D if column G has an entry of 1 and vice versa. I don't think Data Validation will work. Any ideas? Example is if they choose full service in Units A they are unable to choose Units B and vice versa. Any help appreciated.

	ANNUAL FEE	UNITS A	COST	ANNUAL FEE	UNITS B	COST
NSCLC	$100.00		( auto computes )	$60.00		(auto computes)
Late IO	$500.00		( auto computes )	$500.00		( auto computes )

 

[mumps]

My pleasure.

 

[kathleenfarber]

Any idea why this macro stops working? I have resaved the file as an XLSX and went thru the steps multiple times to re-enter the code. Resaved the file as macro-enabled. It still won't work. I'm not sure what I am doing wrong. it was working great and now it's not. :/

 

[mumps]

Did you place the macro in the worksheet code module as I suggested in Post #3?

 

[kathleenfarber]

I sure did. Then something happened to the file by another co-worker. I deleted everything. Saved as XLSX then started back at step 1. It just keeps failing.

 

[jasonb75]

You need to save it as XLSM.

 

[kathleenfarber]

Correct. I cleared everything. Saved at XLSX then started back at step 1 including saving it again as macro-enabled.

 

[mumps]

Could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file (de-sensitized if necessary) that you can post here.

 

[kathleenfarber]

Estimator.xlsm hope this works lol

 

[mumps]

The macro is working properly for me. If I enter a value in D5 and G5 is blank, then nothing happens. If I enter a value in G5 and D5 is not blank, then the message pops up.

 

[jasonb75]

It's working fine for me, it might be your security settings blocking it, or events are currently disabled. Try completely closing excel (everything, not just one workbook), then starting again.