Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

How do I unhide a row when ENTER is pressed in a certain cell?

4 views
Skip to first unread message

Saucer Man

unread,
Apr 13, 2012, 12:16:19 PM4/13/12
to
I want to hide all rows after the last row in a worksheet. When the user
finishes entering data in the last row and hits ENTER in the last cell
(column R) in the last row, I want the next row to "unhide" and the
cursor/selection placed on the first cell in this next row. How can I
accomplish this?

Thanks!


--- Posted via news://freenews.netfront.net/ - Complaints to ne...@netfront.net ---

GS

unread,
Apr 13, 2012, 1:12:43 PM4/13/12
to
Saucer Man submitted this idea :
You can do this via VBA. However, if you simply want to emulate a new
input row to 'appear' after entries in the last row are made, there are
ways to accomplish this using Conditional Formatting and sheet
protection to manage navigation.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion


Don Guillett

unread,
Apr 13, 2012, 1:55:49 PM4/13/12
to
Right click sheet tab>view code>insert this
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count > 1 Or Target.Column <> 18 Then Exit Sub
Rows(Target.Row + 1).Hidden = False
Cells(Target.Row + 1, 1).Select
End Sub

Jim Cone

unread,
Apr 13, 2012, 9:38:49 PM4/13/12
to
Garry,

RE: "However, if you simply want to emulate a new
input row to 'appear' after entries in the last row are made, there are
ways to accomplish this using Conditional Formatting and sheet
protection to manage navigation."

OK, I give up - how do you do the above?
'---
Jim Cone



"GS" <g...@somewhere.net>
wrote in message
news:jm9mqa$u99$1...@dont-email.me...

GS

unread,
Apr 13, 2012, 10:56:21 PM4/13/12
to
Jim Cone wrote on 4/13/2012 :
> OK, I give up - how do you do the above?

Jim,
If you have 'Professional Excel Development' by Bullen, Bovey, Green
there's an example in Chapter4 Worksheet Design. If you don't have the
book it will not be easy to explain how here unless I paste the entire
example into a post. (I don't think doing that would be appropriate<g>)

Jim Cone

unread,
Apr 14, 2012, 12:25:52 AM4/14/12
to
Thanks for the lead, I will see what I can find.



"GS" <g...@somewhere.net>
wrote in message
news:jmap0m$n1k$1...@dont-email.me...

GS

unread,
Apr 14, 2012, 1:04:04 PM4/14/12
to
Jim Cone was thinking very hard :
Best wishes!
Let me know if I can be of any further assistance...
0 new messages