inserting a value in a cell using VBA

[pryest]

I am sure this is a simple problem to solve. I am just not sure the what would be the best way. I have a Excel worksheet that is being used as a survey. Each question has a Cell with a Yes/No drop down list. For each question I have a cell for comments under it. When the User selects No for a question. I would like to have a Message show in the "comment" cell to remind the user to supply comments. How could I do this using VBA? I am just learning VBA and don't know the specific commands to use in Excel to make this work. Thanks.

Mike

 

[SkipVought]

Hi,

Where is the Yes/No Column? Please describe what would happen in painful detail. Please be CLEAR, CONCISE & COMPLETE.

Based on a Worksheet_Change event, selecting one of those values can trigger a procedure.

Right click the sheet tab and select View Code

This is the Code Window for this Sheet Object.



Skip,
[sub]
[red][/red]
[/sub]

 

[AnotherHiggins]

Right click on the sheet tab and select "View Code".

Paste the following into the window:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target = "no" Then
    MsgBox "Please enter a comment"
End If
End Sub

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.