VBA Code that Unhides rows

[Grammarjunkie]

Hi, guys!

I have a bunch of VBA codes to reveal rows depending on the answers of a dropdown in certain cells.
I.E. - If F101 has "Y" or "y", row 102 is revealed, else it stays hidden.

My question is this: some people in my dpt don't use the dropdowns and instead would rather type in the letter (hence my doing Y and y). When they answer "y" in 101, and then press enter to accept it, row 102 is revealed, but they're in cell F103 since row 102 "didn't exist" when they pressed enter.

Is there an easy something to put into the vba code so that when they press enter, it simultaneously goes to F102 as 102 is revealed?


I feel like this is a ridiculous request, and it probably isn't easy by any means. If possible at all. So I have no qualms telling them to get over it or use the dropdowns that I put.

Thanks for any help!

 

[BiocideJ]

Without seeing your code I am somewhat guessing, but couldn't you just put a line of code to activate the Cell immediately after unhiding the row?

Something along the lines of

...your code...
R = [your row number]
Rows(R).Hidden = False
Range("A"&R).Activate

 

[Grammarjunkie]

Without seeing your code I am somewhat guessing, but couldn't you just put a line of code to activate the Cell immediately after unhiding the row?

Something along the lines of

...your code...
R = [your row number]
Rows(R).Hidden = False
Range("A"&R).Activate

Sorry, I always feel like a question is a general thing and specific codes aren't worth mentioning. But if it helps,

If Range("F101") = "Y" Then
    Rows("102").Hidden = False
Else
    Rows("102").Hidden = True
End If

So how does your fit into that? At the end?

 

[BiocideJ]

Assuming you have each row hide/unhide section listed out, you would need to add the following new line to each section (with the correct row number)

If Range("F101") = "Y" Then
    Rows("102").Hidden = False
    Range("F102").Activate
Else
    Rows("102").Hidden = True
End If