Userform to display last record on a sheet

hi All,

i am a beginner in excel VBA programming, i am working on a project where the userform designed for a sheet on a workbook should display the last record whenever it is opened. and if it is opened and a new record is added in the sheet, the form should refresh and display the new record.

Pls help

Hi Leish,

Thks you greatly for the welcome. attached is the workbook.

adebayo.

Originally Posted by Leith Ross

Hello adebayo,

I made a lot of changes to your code to condense it and make it more flexible. You should not have any problems understanding the code but if you do then please ask me for help.

The row number is now displayed in a Label instead of a Text Box. I did this to make validation simpler. The Label has only one event - Click. There is no chance of firing another event through a code change. The Tool Tip Text will tell the user to click the label to change the row. All the buttons work. You will need to restore your SQL connection. It was necessary for me to remove it to troubleshoot the UserForm.

Hi Leith,

Thanks you very much for the smart approach, i have tried it and it is displaying the last record perfectly even beyond my concept!!!,i will like to add a small dynamic unto the userform which is "To have the Userform refresh automatically whenever there is a new data from the SQL link". Presently whenever i closed the userform and reopen it the new data is displayed.
(my link to SQL refreshes every 1 Minute)

Rgds

Adebayo.

Originally Posted by Leith Ross

Hello Adebayo,

Since the SQL link is secure, I can not be sure what is happening in the background. I will see what I can do.

Hi Leith,

Thanks, for the hope, sincere appreciation of your skills as a moderator, will patiently awaits your reply.[/There can never be a second step without the very first]

Hello Leith,

will appreciate your solution, even if it will affect the security of the Sql link.

Thanks in advance

Adebayo

hi Leith,

thanks for the prompt action, i really appreciate your help. i opened the workbook and linked it up to SQl as instructed: following is the scenario observed whenever a new data record is added to sheet(main). The userform2 do not refresh,i can only use the NEXT button or LAST button to see the new data appearing on the form, or i have to close the form and re open before i can see the new data. what i need is to see the new data without using either the next button or LAST button or close and re open the userform2. thanks for preparing to help me further.

Rgds

Adebayo AJAYI