Cell with a certain value to go to...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello
I need a code to do the following
This is for a form I created
If the value in cell N39 is YES then go to cell q36
If the value is something else besides Yes then it should do nothing
Thank you
 
when is this to take place?
When you open it?
when you print it?
When you close it?
etc.
do you want it to stay at Q36 from then on?
How does N39 get changed?
 
bj thanks
This is a protected form (Below are the correct cell numbers)
This is to take place when the person completing the form gets to cell N29
and from the dropdown list (created in validation -List- source =indirect
(B29) selects yes or Lab without (there are only 4 choices in the dropdown
list (Yes , No, lab with, lab without)

If the person selects Yes or lab without then it should go to O31 (that is
skip Q29)
One thing O31 is an option button (created from the forms toolbar) = yes
or no which answers a question on row 31 ) . After that person should be
able to complete the rest of the form

IF the person selects No or Lab with it should go to Q29 then after that O31
. After that person should be able to complete the rest of the form
Thanks BJ Hope this is clear
 
a) Open VB Editor
b) Find your project in the Explorer pane
c) Double click to open the worksheet where your form is
d) Paste this:

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Address = Range("N29").Address Then
If Target = "Yes" Or Target = "Lab with" Then
Range("O32").Select
Else
Range("Q29").Select
End If
End If

End Sub
 
Tevuna Awesome PERFECT thanks!

Tevuna said:
a) Open VB Editor
b) Find your project in the Explorer pane
c) Double click to open the worksheet where your form is
d) Paste this:

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Address = Range("N29").Address Then
If Target = "Yes" Or Target = "Lab with" Then
Range("O32").Select
Else
Range("Q29").Select
End If
End If

End Sub
Click to expand...
 
Back
Top