irresistible007
Board Regular
- Joined
- Nov 24, 2005
- Messages
- 173
I have a Text box and a command button on my sheet (sheet has a freez panes so as the controls should always be visible), and following code to make them alive:
Private Sub CommandButton1_Click()
Dim rng As Range
Set rng = ActiveWorkbook.Sheets("Sheet1").Range("G65536").End(xlUp)
rng.Offset(1, 0).Value = TextBox1.Text
TextBox1.Text=""
End Sub
The thing is that on my monitor 28 rows of excel are shown at a time and so when i make the 29th entry from above controls though the entry sits perfectly on its place but i have manually to scroll down to see it. What i want to know is it possible to get this task automagically... i mean when i make the 29th entry the excel must show it by automatically scrolling down so as i can see the most recent entries without manually scrolling[/b]
Private Sub CommandButton1_Click()
Dim rng As Range
Set rng = ActiveWorkbook.Sheets("Sheet1").Range("G65536").End(xlUp)
rng.Offset(1, 0).Value = TextBox1.Text
TextBox1.Text=""
End Sub
The thing is that on my monitor 28 rows of excel are shown at a time and so when i make the 29th entry from above controls though the entry sits perfectly on its place but i have manually to scroll down to see it. What i want to know is it possible to get this task automagically... i mean when i make the 29th entry the excel must show it by automatically scrolling down so as i can see the most recent entries without manually scrolling[/b]