Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ok try agian. User form LastRow
Hi Hi Hi-
Ok, I am still trying to get my user form to work. Since the help earlier just confused me even more I decided to start with a clean workbook and start from scratch. I have a user form that I want the user to be able to enter data or look at data already in the database using <First <Last<Next and <Previous buttons and it show the record. Soooooo the following is as far as I have gotten and have hit a wall. The cbofirst button works but I can't seem to get the cboprev button to work. Thank you, Jennfier Remember I am very green at this I need a lot of hand holding! Private Sub cmdFirst_Click() RowNumber.Text = "2" End Sub Private Sub cmdPrev_Click() Dim r As Long If IsNumeric(RowNumber.Text) Then r = CLng(RowNumber.Text) r = r - 1 If r 1 And r <= LastRow Then RowNumber.Text = FormatNumber(r, 0) End If End If End Sub Private Sub cmdSave_Click() End Sub Private Sub RowNumber_Change() GetData End Sub Private Sub DisableSave() cmdSave.Enabled = False cmdClose.Enabled = False End Sub Though daily learning, I LOVE EXCEL! Jennifer |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I fill a cell in a user form from a selection on same form? | Excel Discussion (Misc queries) | |||
How to: User Form to assign a user defined range to a macro variab | Excel Programming | |||
Go to lastrow using other column's lastrow | Excel Programming | |||
I am looking to see if anybody has an equivalant user form to Outlooks CONTACT form | Excel Programming |