Looking for Help For a Excel Based Form

[flyguide7]

I have created a form in Excel 2016. This form uses a lot of drop down lists. I have a cell (N29) which has a drop down list with 3 choices (Yes, No and N/A). When the user selects "Yes" I would like to jump (navigate) to cell A36, where the user would be prompted to enter text in that cell (A36).

I have tried using an IF formula but with no luck since my Excel skills are minimal at best. Any help would be appreciated.

Cheers!

 

[mikerickson]

It sounds like you are using "form" to describe a worksheet rather than a userform.

These drop-down lists, are the Data Validation or controls from the Forms menu or ActiveX controls.
If they are Validation drop-down lists, then they can't do what you want.

 

[flyguide7]

It sounds like you are using "form" to describe a worksheet rather than a userform.

These drop-down lists, are the Data Validation or controls from the Forms menu or ActiveX controls.
If they are Validation drop-down lists, then they can't do what you want.

Thanks for your reply. Yes you are correct, I am using a table as an electronic report form for my business. the drop down lists are Data Validation.

 

[Forever_EX]

Range("A36").Activate

 

[mikerickson]

Thanks for your reply. Yes you are correct, I am using a table as an electronic report form for my business. the drop down lists are Data Validation.

If you are open to using VBA, you could put this in the sheet's code module.

Private Sub Worksheet_Change(ByVal Target As Range)
    With Target
        If .Address = "$N$29" Then
            If .Text = "Yes" Then Me.Range("A36").Select
        End If
    End With
End Sub

You should also put Validation on A36 with the custom formula =TRUE (i.e. everything allowed) and the input message of your choice.