ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Using a button to scroll Up & Down a Database on a Userform (https://www.excelbanter.com/excel-programming/444400-using-button-scroll-up-down-database-userform.html)

Cimjet[_3_]

Using a button to scroll Up & Down a Database on a Userform
 
Hi Everyone
This macro takes me to the first entry on my database, i would like to be able
to scroll Up&Down with a button
Can anyone give me a macro to do that.
Any help would be very much appreciated.
Regards
John
Private Sub cmnbFirst_Click()
Dim FirstCl As Range
Set FirstCl = Range("a1").End(xlDown).Offset(1, 0)
With Me
.cmbAmend.Enabled = False
.cmbDelete.Enabled = False
.cmbAdd.Enabled = True
.TextBox1.Value = FirstCl.Value
.TextBox2.Value = FirstCl.Offset(0, 1).Value
.TextBox3.Value = FirstCl.Offset(0, 2).Value
.TextBox4.Value = FirstCl.Offset(0, 3).Value
.TextBox5.Value = FirstCl.Offset(0, 4).Value
End With
End Sub



All times are GMT +1. The time now is 01:19 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com