Previous Topic Next Topic

VBA - Excel 2007 Removing Values

Closed
BobBing Posts 1 Registration date Friday March 16, 2012 Status Member Last seen March 16, 2012 - Mar 16, 2012 at 01:33 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 25, 2012 at 07:37 AM
Hello,

I am working with excel right now with their data validation feature.

I have a yes no option in cell A3.
In cell A4 I also have a dropdown selection.
What I want to be able to do is when A3 = "No" I want the Data validation dropdown for A4 to = "" (Blank).

I have added a default button in for the overall sheet, so by default A3 is yes and A4 has a value, but if the person selects no for A3 I want A4 to automatically go blank as the row is hidden when No is selected, and I don't want a value to be calculated for A4 at the end of my sheet.

I am not sure how to code this. Any help would be greatly appreciated!

-Bob

Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 25, 2012 at 07:37 AM
You have to do some thing like this

https://ccm.net/forum/affich-269392-dropdown-lists-in-excel-2007
or may be lock the cell
0

Similar discussions

Can't remove threat with Windows Defender
Babarali4 -
ravida_1351 -

2 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses