Excel Form Help

[iuianj07]

Hello Guys,

I have an excel file, and created a FORM. This form has a LoanNumber Textfield, and I have an excel worksheet that has the column LoanNumber.

What I would like to do though, is on the FORM, the LoanNumber textfield will show the LoanNumbers on the worksheet, then I would like to create a Next and Previous Buttons, to sort through the LoanNumbers within the worksheet.

Can you help me create the VBA code for the LoanNumber Textfield, Next and Previous buttons on the form?

Thanks and any help is greatly appreciated.

 

[SkipVought]

Hi,

Please post VBA questions in forum707.

ALSO, when you repost this question in forum707, please clarify FORM. Do you mean a UserForm object or are you referring to your sheet as a FORM?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[iuianj07]

Thanks SkipVought! ;-)