Hello, I have found myself stuck again and would appreciate any help!
My worksheet asks a series of questions and has dropdown boxes next them it to select an answer. For example Cell E6: "Are you aged 18-65?" with possible answers next to it in F6 "Yes" or "No"
What I want is if they answer "Yes", to then jump to the next question which is several rows down (Cell E20). Or if they answer No to jump to Cell E30
I tried the following where AA:1 has a value of "Yes" and AA:2 as "No"
Dim st3 As String
st3 = Sheet5.Range("AA:1").Value
Dim st4 as String
St4 = sheet5.Range("AA:2").Value
If Sheet5.Range("f:6") = st3 Then
Activesheetrange("E:20").Select Or
If sheet5.range("F:6") = st4 Then
Activesheetrange("E:30").Select
End If
but it doesn't work! Any help would be appreciated, thank you
Bookmarks