Using Customize Userform rather than Excel Built-In Userform

[Like to learn]

Excel 2010 & Win 7

I created Excel Table from Range of Cells.

Table has 10 Fields

Textbox_Company, Textbox_SalespersonName, Textbox_SalespersonNumber, Textbox_Email and so forth.​

And currently has 100 Rows.

To update this Table, I prefer designing my own Userform rather than use Excel Built-In Userform.

I designed the Userform they way I like.

AND now here is the QUESTION.

To use the Built-In Userforms is very Easy. You just have to select any cell in the Table and Click the Forms button and there it is.

How do I connect/relate the Userform I just created to the Table?

I spent considerable hours searching online to find how to do this.

Please keep in mind that I have over the years thought myself Excel, using complicated formulas and macros with the help of online community. Now I need help with Tables and Userforms.

I would be very thankful for any help for any help I can get.

 

[dmt32]

in you online seraching - did you find this site:
Create an Excel UserForm

 

[Like to learn]

Thanks, Let me do research in there.

 

[Like to learn]

Thanks dmt32. That helped. It was easy to understand especially after finding couple of errors in their code.

Where can I find similar codes to scroll through the table. Like PREV, NEXT, DELETE, FIND?
I already have buttons setup just need the basic code.

Thanks

 

[dmt32]

have look here: The Spreadsheet Page - Data Form Home
The application to download is free but you may have to make a payment to the author if you want access to source code.

or you can just google - plenty of stuff out there.

Good hunting

Dave