how do i disable row/column from yes/no validation list box?

[manjumukesh]

Hi,

I have produced formula in two columns, one cell in other column set to a validation list containing 'Yes,No'.

If the user selects 'no' for a particular cell, i want two formula column disable.
If the user selects 'yes' for a particular cell, formula's column will remain active.

Please can you help me?

Mukesh

 

[fadee2]

hi manjumukesh,

Welcome to the Board.

I'm not sure I get your query entirely. Please elaborate it a bit further as there are a number of questions in regards to the same.
for instance,
1. How excel would interpret which cell the user has selected, while selecting "No" from the data validation list?
2. What do you mean by column disable? is it to Hide the Column?

I would suggest providing part of your worksheet along with your query for better understanding. You can use xl2bb addin to do so, or make use of any free file sharing service like dropbox or onedrive.

 

[manjumukesh]

hi manjumukesh,

Welcome to the Board.

I'm not sure I get your query entirely. Please elaborate it a bit further as there are a number of questions in regards to the same.
for instance,
1. How excel would interpret which cell the user has selected, while selecting "No" from the data validation list?
2. What do you mean by column disable? is it to Hide the Column?

I would suggest providing part of your worksheet along with your query for better understanding. You can use xl2bb addin to do so, or make use of any free file sharing service like dropbox or onedrive.

Yes i want hide the column, when i select option 'no'.

 

[fadee2]

In that case, how about using a command button instead of using Yes/No in a data validation list.
If so, then create a form button on your worksheet and use the below code in a standard module.

Sub Button5_Click()
s = ActiveCell.Column
ans = MsgBox("Do you want to hide selected column?", vbYesNoCancel + vbQuestion)
    If ans = vbYes Then
        Columns(s).EntireColumn.Hidden = True
    End If
End Sub

hth....