Looking for Help For a Excel Based Form

flyguide7

New Member
Joined
Feb 8, 2019
Messages
2
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!
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

mikerickson

MrExcel MVP
Joined
Jan 15, 2007
Messages
23,984
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

New Member
Joined
Feb 8, 2019
Messages
2
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.
 

mikerickson

MrExcel MVP
Joined
Jan 15, 2007
Messages
23,984
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.
Code:
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,129,752
Messages
5,638,162
Members
417,011
Latest member
Amaden95

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top