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

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

mikerickson

MrExcel MVP
Joined
Jan 15, 2007
Messages
24,220
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
24,220
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.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,167,969
Messages
5,856,584
Members
431,821
Latest member
chaftun

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