View 1st Record through User Form Automatically

Hi All,

I have a User Form in Excel which is now working absorlutely perfect, with some help from you guys on here, I have one last question, When I click first Record on the form it display the very first record with Text in the spreadsheet, Can anyone show me how to have the first Records Data show automatically in the form when the form is launched?

Also I have set Record 3 as the first record becasue 1 & 2 have the headers in them, but when I click previous record it still shows them, can i get around this somehow.

Thanks Guys.

Shazz
x

Need to see the code, but it's not a good idea to use two rows for the header

Not sure but looking through the SelRow could be overwriting RowNumber.

So you've not learned what the code is doing?

Instead of posting all that code it would have been more useful to attach the workbook.

I have not looked at the workbook but I think you jsut change the Previosu button code to

Please Login or Register  to view this content.

and then Userform_Initialize to

Please Login or Register  to view this content.

My pleasure, and thank you.

Please do not forget to mark the thread Solved. (see FAQ)