Prompt for additional data in excel

[laurabro]

Please can smeone tell me how I prompt someone for information in a cell based on an entry in another cell?

eg. In A1, I have a yes/no question - if I enter yes, I want excel to prompt for a value to be entered in B1. A negative response would require no action.

 

[ETID]

Use data validation on column A and set it to "List"
and type YES,NO in the source box.

Then this code in the worksheet change event.

Private Sub Worksheet_Change(ByVal Target As Range)

If ActiveCell.Column <> 1 Then
Exit Sub
Else

If UCase(ActiveCell.Value) = &quot;YES&quot; Then Cells(ActiveCell.Row, 2) = &quot;NO&quot; 'change 2 to your col ref
End If

End Sub

 

[ETID]

Oh ...sorry

change the last line in the sub to this


If UCase(ActiveCell.Value) = &quot;YES&quot; Then Cells(ActiveCell.Row, 2).Select: ActiveCell.Value = InputBox(&quot;Value for Col B&quot
End If